Anuj Chauhan

How to to verify case sensitive columns in SQL SERVER having Case insensitive Collation.

Use this query

SELECT * FROM LoginData WHERE username ='something' AND password COLLATE SQL_Latin1_General_CP1_CS_AS LIKE 'askjashAA';

OR

SELECT * FROM LoginData WHERE username LIKE 'something' AND password COLLATE SQL_Latin1_General_CP1_CS_AS LIKE 'askjashAA';

SQL Case insensitive SQL, check username password