Re: case independent LIKE select?

My preferred solution to this problem is to have two columns both of which contain the name, but one of the columns contains the name in mixed case and the other in Upper case.eg name, and uppername Then the queries and indexes use the uppername column and the output uses the name column.

You might also consider looking at the soundex function. It will allow you to retrievce a list of similar sounding names, provided they begin with the same letter.

Ken Gaul (06) wrote in message
<38859F66.4B2F4B3D_at_gaul-edin.freeserve.co.uk>...
>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 - 09:26:59 CST