Re: Please Help

Hi,

Try:

Select column_name
from my_table
where upper(column_name) like upper( '%variable%' )

grt

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.
>
>
Received on Wed Dec 16 1998 - 17:09:31 CST