The easiest way to achieve this is to create another field for the one you
need to search on. Create a trigger on update to set the field to the upper
case value of the regular field value. Then use like and convert the search
string to upper case. Of course, this becomes more of a problem if you have
more than a couple of fields to search like this but it is, IMO, the
quickest way to achieve what you want. I hope there are plans for future IB
versions to have a case-sensitive flag for the like command. Either that or
make the containing keyword more flexible so that you can specify substr
position using wild cards.

Woody

----- Original Message -----
From: <ian.mellor@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, September 03, 2001 11:32 AM
Subject: [ib-support] containing, like, =


> We have a need for a case insensitive search on all words within a field.
>
> If we use containing we get the results we need, however we lose index
> benefits. Likewise if we use "like '%value%'" we cant use an index.
>
> Is there a "simple" way of meeting our needs?
>
> Thanks in advance..
>
> Ian
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
> Gender:
> Female
> Male
> Weight:
> lbs. kg.
>
>
>
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>