A partial solution

WHERE UPPER(NAME) LIKE 'WOOD%'

I don't know if this uses an index or not and if it
degrades speed significantly, since UPPER is not a UDF.


Hans

-----------------------------------

Woody wrote:

>
> LIKE is case sensitive, that's why I'd like to have a flag to tell it not to
> be. I can go either way, by changing the LIKE command or the CONTAINING
> command. The problem is you have to sacrifice one thing for the other
> depending on which command you want to use. CONTAINING finds the string
> anywhere inside the field and LIKE let's you specify the string using wild
> cards.
>
> Woody
>
> ----- Original Message -----
> From: <hans@...>
> To: <ib-support@yahoogroups.com>
> Sent: Monday, September 03, 2001 6:42 PM
> Subject: Re: [ib-support] containing, like, =
>
> > >I hope there are plans for future IB
> > >versions to have a case-sensitive flag for the like command
> >
> > I thought LIKE was case sentive and LIKE 'NAME%' does use an index,
> > but LIKE '%NAME%' does not. However CONTAINS 'NAME' is case
> > in-sensitive and doesn't use an index.
> >
> > Hans
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> > 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.
> >
> >
>
>
> 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/