Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: case independent LIKE select?

Re: case independent LIKE select?

From: Andy <withheld_at_emailaddress.com>
Date: Wed, 19 Jan 2000 10:46:29 GMT
Message-ID: <388595b6.168364494@news.colt.net>


On Wed, 19 Jan 2000 16:11:08 +1100, "Suzanne Edgecombe" <suzanne.edgecombe_at_agso.gov.au> wrote:

>try 'select upper(name) from users group by name'
>

I actually want the data to come out like:

Alpha
bravo
charlie
Delta
etc...

i.e. I want the ORDER BY to be case-insensitive, but the output must be the actual field contents.

Is this possible? Received on Wed Jan 19 2000 - 04:46:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US