It is very simple, by using COLLATE you can compare the string with case Example : Select  * from TableName Where ColumnaName COLLA...

String Comparision with Case sensitive In SQL Server

6:38 AM Raghunatha 0 Comments

It is very simple, by using COLLATE you can compare the string with case
Example :


Select  * from TableName Where ColumnaName COLLATE SQL_Latin1_General_Cp1_CS_AS='ValuetobeSearch'

0 comments:

Subscribe to: Post Comments (Atom)
Powered by Blogger.