65.9K
CodeProject is changing. Read more.
Home

Case sensitive string comparison in SQL

starIconemptyStarIconemptyStarIconemptyStarIconemptyStarIcon

1.00/5 (1 vote)

Mar 9, 2010

CPOL
viewsIcon

7920

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'