Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / Languages / SQL

Case sensitive string comparison in SQL

1.00/5 (1 vote)
9 Mar 2010CPOL 1  
select * from table where and column COLLATE SQL_Latin1_General_CP1_CS_AS = 'G%E3%97O%D7'
select * from table where and column COLLATE SQL_Latin1_General_CP1_CS_AS = 'G%E3%97O%D7'

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)