Re: Like operator and Parameter

[Quoted] "OraRepDvlpr" <itsashok_at_gmail.com> wrote in message news:1114208034.007157.35620_at_z14g2000cwz.googlegroups.com...
> 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
>

[Quoted] i assume this is a query within Oracle Reports

please be more specific on how it does not work -- the syntax certainly looks correct. are you perhaps running in a case-sensitive issue? what value are you supplying for the parameter, what results are you expecting, and what results are you getting?

++ mcs Received on Sat Apr 23 2005 - 04:19:18 CEST