Re: Case Sensitivity in select
From: sirirut vanichayobon <svanicha_at_cs.ou.edu>
Date: 1999/08/27
Message-ID: <37C715FD.BC8628AA_at_cs.ou.edu>#1/1
Date: 1999/08/27
Message-ID: <37C715FD.BC8628AA_at_cs.ou.edu>#1/1
select * from workds
where soundex(word) = soundex('hello')
-sirirut-
Stu wrote:
> Is it possible to set a parameter which will make a select statement
> case insensitive. i.e. so that select * from words where word='hello'
> will bring back records where word='HELLO' or 'Hello'.
Received on Fri Aug 27 1999 - 00:00:00 CEST