Re: case independent LIKE select?

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