How to do a case sensitive search in WHERE clause (I'm using SQL Server)? -

I want to find case-sensitive in your SQL query. But by default, does not consider the case of SQL Server string.

Any ideas on how to issue SQL queries sensitive search?

The default case insensitive.

The link Quote:

  SELECT from 1 dbo.Customers where CustID = @CustID COLLATESQL_Latin1_General_CP1_CS_AS and CustPassword = @CustPassword COLLATESQL_Latin1_General_CP1_CS_AS