LIKE
select from userinfo where usertype LIKE BINARY 'FREE'
select from userinfo where usertype LIKE BINARY 'free'
select * from <table name=""> where (binary_checksum(Usertype) = binary_checksum('free'))</table>
COLLATE
ALTER TABLE userinfo ALTER COLUMN UserType VARCHAR(10) COLLATE SQL_Latin1_General_CP1_CS_AS
binary_checksum
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)