Re: Like operator and Parameter

OraRepDvlpr wrote:

> Hi group,
> I am new to oracle reports and currently going thru the learning
> curve. I need to use a parameter in Parameter Form in SQL clause.
>
> SELECT a,b,c from TD where TD.e like '%'||:p_from_Form||'%'
>
> The above SQL does not work.
> Any idea

In USER PARAMETERS create the parameter

In the SQL query under Queries do something like this:

select a,b,c
from td
[Quoted] where e LIKE '%' || :P_from_form || %';

Should work just fine.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)