How to check case sensitive data in SQL Server?


Converting data to binary type before comparison

SELECT * FROM dbo.TableName    WHERE CAST(Password AS varbinary(15)) = CAST(“Password” AS varbinary(15))
AND CustPassword = @CustPassword

How useful was this post?

Click on a star to rate it!

Leave a Reply

Your email address will not be published. Required fields are marked *