Re: Simple SQL Question

In article <953741685.26442.0.pluto.d4ee154e_at_news.demon.nl>, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> My resolution for this issue has always been allowing the operator to
enter
> nothing (ie NULL) and concatenating the % always. If he enters nothing
the
> query string equals '%'
> which is exactly what you want.
> Otherwise you need to use a combination of decode and replace or
translate
> (I always forget the difference).
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
Thanks anyway, I figured out how to write a trigger to convert my parameters into what I need them to be.

Jason

> <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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 22 2000 - 20:14:17 CET