Re: Case Sensitivity in select
From: Darren Roche <darren.roche_at_cableol.co.uk>
Date: 1999/09/01
Message-ID: <7qk3sh$hmt$1_at_nclient9-gui.server.ntli.net>#1/1
Date: 1999/09/01
Message-ID: <7qk3sh$hmt$1_at_nclient9-gui.server.ntli.net>#1/1
Yes, of course.
Try this....
select * from words
where UPPER(word) = 'HELLO';
Where it will bring back all variations i.e. Hello, hello, HeLlO, etc.
Regards,
Darren.
Darren.roche_at_cableol.co.uk
Stu wrote in message <37C524EA.CC828BE7_at_dkmsoft.com>...
>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 Wed Sep 01 1999 - 00:00:00 CEST