Re: Simple SQL Question

[Quoted] My resolution for this issue has always been allowing the operator to enter [Quoted] nothing (ie NULL) and concatenating the % always. If he enters nothing the query string equals '%'
which is exactly what you want.
[Quoted] Otherwise you need to use a combination of decode and replace or translate [Quoted] (I always forget the difference).

Regards,

Sybrand Bakker, Oracle DBA
<jehall_at_my-deja.com> wrote in message news:8banjv$9h$1_at_nnrp1.deja.com...
> In my ORACLE Reports 6.0, I have a parameter value in which I wanted to
> convert it into something else. For example, if ALL is in the combo
> box, I want to convert it into a % sign, so I can wildcard in the Query.
> The only function I see available is a validation function that must
> return true or false? Can I put conversion logic here? Please Help!
>
> Thanks,
>
> Jason
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 22 2000 - 17:09:52 CET