Re: case independent LIKE select?

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 - 11:32:54 CST