Re: Case Sensitivity in select
From: Ed Prochak <prochak_at_my-deja.com>
Date: 1999/09/01
Message-ID: <7qjnj1$sje$1_at_nnrp1.deja.com>#1/1
Date: 1999/09/01
Message-ID: <7qjnj1$sje$1_at_nnrp1.deja.com>#1/1
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 - 00:00:00 CEST