Is the LIKE operator case-sensitive with SQL Server?

asked12 years ago
last updated4 years ago
viewed181.6k times
Up Vote124Down Vote

In the documentation about the LIKE operator, nothing is told about the case-sensitivity of it. Is it? How to enable/disable it?

I am querying varchar(n) columns, on an Microsoft SQL Server 2005 installation, if that matters.