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

If you are interested in Entity Framework approarch:

var customers = context.Customers
.Where(c => EF.Functions.Collate(c.Name, "SQL_Latin1_General_CP1_CS_AS") == "John")
.ToList();

See:

[To see links please register here]

Can be done via [changing the Collation][1]. By default it is case insensitive.

Excerpt from the link:

SELECT 1
FROM dbo.Customers
WHERE CustID = @CustID COLLATE SQL_Latin1_General_CP1_CS_AS
AND OrderID = @OrderID COLLATE SQL_Latin1_General_CP1_CS_AS

Or, [change the columns to be case sensitive][2].

You can also apply COLLATE to LIKE to make it case sensitive - e.g.,

SELECT *
FROM tbl_Partners
WHERE PartnerName COLLATE SQL_Latin1_General_CP1_CS_AS LIKE 'MyEx%' COLLATE SQL_Latin1_General_CP1_CS_AS


[1]:

[To see links please register here]

[2]:

[To see links please register here]