|
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' ???!!!
>
Navigation:
[Reply to this message]
|