Re: case independent LIKE select?

From: Suzanne Edgecombe <suzanne.edgecombe_at_agso.gov.au>
Date: Wed, 19 Jan 2000 16:11:08 +1100
Message-ID: <ZHbh4.117$oZ1.3092635668@news.interact.net.au>

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

cheers

sue e

Andy wrote in message <3884a395.106370036_at_news.colt.net>...
>On 18 Jan 2000 03:54:09 GMT, skurosky_at_aol.com (SKurosky) wrote:
>
>>>LIKE search for keywords in article titles regardless of case. I have no
>>
>>How about..
>> WHERE UPPER(article_title) LIKE 'string in upper case'
>>
>>OR
>> WHERE LOWER(article_title) LIKE
>>'string in lower case'
>>
>>Is your article title mixed case??
>>HtH
>>Sandy
>>
>
>My server is down at the moment. Can the same be applied to the ORDER
>BY? i.e. "SELECT name FROM users ORDER BY UPPER(name);"
>
Received on Tue Jan 18 2000 - 23:11:08 CST