Re: Case Sensitivity in select

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 - 17:49:33 CDT