Case sensitive string comparison in SQL

Neh.C

Rate me:

1.00/5 (1 vote)

8 Mar 2010CPOL

7.8K

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)

Written By

Neh.C

Software Developer (Senior)

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.