Sql query

Question

hello friends If at all i want to compare values from database without ignoring case then how can i do this in Sql Server? for example : suppose i have this table TblLogin UserName Password user1 Vikram user2 csharpcorner user3 microsoft Select UserName From TblLogin Where Password='vikram' (here i m passing password in small case but in the table that is in title case) this query will return user1 as result which is incorrect according to my requirement. i want to get UserName only when password is in correct case. i.e. 'Vikram' can you tell me how to write this type of query?

Ramesh Maruthi · Answer

SELECT UserName FROM TblLogin WHERE Password COLLATE Latin1_General_CS_AS = 'vikram' Adding COLLATE Latin1_General_CS_AS makes the search case sensitive. Default Collation of the SQL Server installation SQL_Latin1_General_CP1_CI_AS is not case sensitive. To change the collation of the any column for any table permanently run following query. ALTER TABLE TblLogin 1 ALTER COLUMN Password VARCHAR(20) COLLATE Latin1_General_CS_AS

Vikram Agrawal · Answer

thanks to all. is there any other way to do this?

Dipankar Biswas · Answer

http://stackoverflow.com/questions/896367/how-to-check-case-sensitive-password-in-sql-server08

UserName	Password
user1	Vikram
user2	csharpcorner
user3	microsoft