Re: Case insensitive query.
From: G. Cristian Palma A. <gpalma_at_dcc.uchile.cl>
Date: 1995/10/09
Message-ID: <45bh3v$jv_at_antilen.dcc.uchile.cl>#1/1
Date: 1995/10/09
Message-ID: <45bh3v$jv_at_antilen.dcc.uchile.cl>#1/1
In article <44rsj2$4gt_at_tel.den.mmc.com> thomas_at_sde.mdso.vf.ge.com (Thomas Kim) writes:
>
>
>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.
And if you use the UPPER command ?
For example: select *
from table where upper(col1) = 'TOYS'
Cristian Received on Mon Oct 09 1995 - 00:00:00 CET