Re: Case Sensitivity in select

From: Ed Prochak <prochak_at_my-deja.com>
Date: Wed, 01 Sep 1999 17:26:10 GMT
Message-ID: <7qjnj1$sje$1@nnrp1.deja.com>

Sorry Sirirut, but your query fails. He is only looking for CASE insensitivity. Yours provides spelling insensitivity. For example, yours might also return 'helloe', 'hallo', and others.

In article <37C715FD.BC8628AA_at_cs.ou.edu>, sirirut vanichayobon <svanicha_at_cs.ou.edu> wrote:
> 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'.
>
>

--
Ed Prochak
Magic Interface, Ltd.
ORACLE services
440-498-3700 <<<NOTE new number

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 01 1999 - 12:26:10 CDT