How To do Case Sensitive String Match in SQL Server

Using:

 COLLATE SQL_Latin1_General_CP1_CS_AS  

Example:

 select * from tblUser where userpwd='aBcD.123' COLLATE SQL_Latin1_General_CP1_CS_AS ;