Monday 21 May 2012

Case sensitive search in sql server


SELECT  *
FROM    TableName
WHERE   [ColumnName] COLLATE LATIN1_GENERAL_CS_AS = ‘searchKey’

No comments:

Post a Comment