Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Case Sensitivity in select
you can also use:
SELECT * from words
WHERE LOWER(word) = 'hello'
Both will return the same results, any case variation of the word Hello.
( I thought it interesting that I saw the original post before I went to school today, and when in class we learned these commands, talk about timing...lol)
Darren Roche wrote in message <7qk3sh$hmt$1_at_nclient9-gui.server.ntli.net>...
>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 Fri Sep 03 1999 - 02:14:39 CDT