Re: Please help
From: Nick B <nickb_at_btinternet.com>
Date: Wed, 16 Dec 1998 11:53:06 +0000
Message-ID: <36779F22.7840_at_btinternet.com>
Date: Wed, 16 Dec 1998 11:53:06 +0000
Message-ID: <36779F22.7840_at_btinternet.com>
[Quoted] Use UPPER (or LOWER) on both sides of the LIKE statement:
WHERE UPPER(name) LIKE UPPER(search_pattern)
Be warned that this will NOT use any index on the 'name' column
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.
Received on Wed Dec 16 1998 - 12:53:06 CET