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