Tuesday, October 9, 2007

MS SQL server: How can I do a case-sensitive comparison on a SQL Server installed with a case-insensitive sort-order?


select * from my_table
where convert(varbinary(4), my_column) = convert (varbinary(4), 'teST')

No comments: