Re: Case insensitive query.
From: Bobby S. Mukundan <bobby_at_sdt.com>
Date: 1995/10/06
Message-ID: <453vfn$ram_at_aadt.sdt.com>#1/1
>>
>>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.
Date: 1995/10/06
Message-ID: <453vfn$ram_at_aadt.sdt.com>#1/1
ccrissma_at_ucs.att.com (ccrissma_at_ucs.att.com) wrote:
>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.
Try select * from table where upper(col1) = upper(value); Received on Fri Oct 06 1995 - 00:00:00 CET