Posted by Erland Sommarskog on 11/22/06 11:24

klabu (klabu@klabucom) writes:
> Sqlserver is case insensitive in this way ?
> for example:
> select....where col1 like '%BURG%'
>
> will return 'Burger King' ???!!!

Maybe. It depends on the collation of col1. In SQL Server you can specify
the collation per column, although normally it's the same for all columns in
a database.

Default when you install SQL Server is a case-insensitive collation.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Severe performance hit with NCHAR queries
• Prev in forum: Re: Shrinking database log used for mirroring
• Thread view: Re: case insensitive

[Reply to this message]