Re: Please HELP

Steven wrote:
>
> hi,
>
> l'm using "LIKE" for for my search engine,
>
> May l know, is there any way to make the search result
>
> non case sensitive.
>
> e.g
>
> If my database's has a value named "Wood",
>
> when l do a search on this keyword "wood".
>
> " Wood" would be one of the potential answer.
>
> Thank You.
>
> --
> With regards
> Steven
>
> Steven Koh, Internet Software Engineer,
> Mediaworks, Pacific Internet Pte. Ltd.,
> 77 Science Park Drive, 04-09/12
> Cintech III, Singapore Science Park,
> Singapore 118256.
>
> Tel: (65) 7711305;
> Fax: (65) 8728523
> www.mediaworks.com.sg, www.pacific.net.sg

Steven,

It is my understanding (i.e., pre-8.x) that you have to do something like (pardon the pun):

  SELECT * FROM MYTABLE WHERE UPPER(THENAME) LIKE '%WOOD%'; If 'wood' is the entire string, then you don't need the 'LIKE':

  SELECT * FROM MYTABLE WHERE UPPER(THENAME) = 'WOOD'; Yours,

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Wed Dec 16 1998 - 04:51:16 CST