Re: Case insensitive query.
From: McGrath Glenda <glenda_at_beta.cc.ukans.edu>
Date: 1995/10/03
Message-ID: <44s40t$lg8_at_newshost.lanl.gov>#1/1
Date: 1995/10/03
Message-ID: <44s40t$lg8_at_newshost.lanl.gov>#1/1
In article <44rsj2$4gt_at_tel.den.mmc.com>,
Thomas Kim <thomas_at_sde.mdso.vf.ge.com> 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.
Try:
SELECT *
FROM table
WHERE lower(col1) like 'toys%'
or to be even more sure it will work try:
SELECT *
FROM table
WHERE lower(col1) like lower('toys%')
glenda_at_lanl.gov Received on Tue Oct 03 1995 - 00:00:00 CET