Monday 21 May 2012

Case sensitive search in sql server


SELECT  *
FROM    TableName
WHERE   [ColumnName] COLLATE LATIN1_GENERAL_CS_AS = ‘searchKey’
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)