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'

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

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.