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