Re: case independent LIKE select?

Missed the start of this thread but looks like you want something like.....

select name from users
where upper|(name) like 'WHATEVER%'
order by upper(name)

The only thing you can't do is group by upper(name) but depending on what you are actually doing there are ways and means.

What about selecting upper(name) and name but not displaying upper(name)?

Ken.

Andy wrote:

> 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 - 05:26:31 CST