ok, thanks for your replay to my email.

Can I use CONTAINING statement as well as LIKE statement ? that is,
searching for a substring ?

thanks,
german

At 03:37 PM 08/04/2003 -0500, you wrote:

> > hi,
> >
> > is there any way to tell firebird no use case sensitive search ?
> >
>
>You can either use an UPPER function in a UDF, not sure if it's built in to
>the latest FB or not, or use the CONTAINING clause for searches. It searches
>using a case-insensitive comparison.
>
>Woody (TMW)
>
>[How many of you believe in telekinesis? Raise my hands....]
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/