Re: LIKE -> Non Casesensitive Query

Translate both sides to the same case in the where clause.

lance mottley wrote:

> Hi!
>
> What is the best way to do the following select without worrying about
> case:
>
> String d='g';
> select name from org where name like " + d + "%"
>
> so if the table has:
>
> ganc
> Good Stuff
> ganger
>
> it should return everything!!
>
> thanks
Received on Tue Apr 24 2001 - 11:57:10 CDT