Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |