Posted by Aaron Bertrand [SQL Server MVP] on 11/21/06 18:39

By default, yes. If you want the query to be case sensitive, you have
several options. Well, some only port easily for equality rather than
LIKE...

http://sqlserver2000.databases.aspfaq.com/how-can-i-make-my-sql-queries-case-sensitive.html




"klabu" <klabu@klabucom> wrote in message
news:12m6h19lhljpr65@corp.supernews.com...
> Sqlserver is case insensitive in this way ?
> for example:
> select....where col1 like '%BURG%'
>
> will return 'Burger King' ???!!!
>

[Back to original message]