Re: Case insensitive query.

In article <44rsj2$4gt_at_tel.den.mmc.com>, thomas_at_sde.mdso.vf.ge.com (Thomas Kim) wrote:

>In Oracle is there a way to perform a case insensitive
>query? For example: Select * from table where col1 LIKE 'toys',
>where a correct response will include TOYS, Toys, toys, or ToYs etc.

select * from table where upper(col1) like upper('toys');

Using the upper() function on col1 will disable the use of any index you have on the column, however; a full scan will be forced.

Joel

-- 
Joel D. Elkins
jdelkins_at_lilly.com