Case sensitive comparisons in SQL Server
Some time we need to compare some data in binary see the examples:
SELECT * FROM TABLE1 WITH (NOLOCK) WHERE convert(varbinary(255), PASS) = convert(varbinary(255), ‘RAGHU’)
Normal comparison:
SELECT * FROM TABLE1 WITH (NOLOCK) WHERE convert(varbinary(255), PASS) = convert(varbinary(255), ‘Raghu’) AND PASS= ‘TEST’
Uuse the BINARY_CHECKSUM function:
SELECT * FROM TABLE1 WITH (NOLOCK) WHERE BINARY_CHECKSUM(answer) = [...]
Filed under: SQL String comparisons | Tagged: BINARY_CHECKSUM, Case sensitive comparisons in SQL, comparisons in SQL, Microsoft SQL server, MSSQL, MSSQL BINARY_CHECKSUM, MSSQL server, MSSQL string compare, MSSQL String comparisons tips, SQL best way to compare string, SQL help, SQL Server, SQL varbinary method | Leave a Comment »
