Check how much technoledge do you have??
Enjoy The world of "Technoledge".
This blog is all about Technology.
Latest Tech-news, Tips & Tricks, Fun Stuffs for Internet, Computer, Site etc.
If you have something more technoledge, please share it with others by posting here.
If any one want to post an article on this site or he want authors rights please contact me at email@example.com.
Monday, November 16, 2015
How doing a case sensitive search in SQL Server?
Question: How doing a case sensitive search in SQL Server?
If Column1 of Table1 has following values ‘CaseSearch, casesearch, CASESEARCH, CaSeSeArCh’, following statement will return you all the four records.
To make the query case sensitive and retrieve only one record (“casesearch”) from above query, the collation of the query needs to be changed as follows. SELECT Column1FROM Table1WHERE Column1 COLLATE Latin1_General_CS_AS = 'casesearch'
Adding COLLATE Latin1_General_CS_AS makes the search case sensitive.
Default Collation of the SQL Server installation SQL_Latin1_General_CP1_CI_AS is not case sensitive.
To change the collation of the any column for any table permanently run following query. ALTER TABLE Table1ALTER COLUMN Column1 VARCHAR(20)COLLATE Latin1_General_CS_AS
To know the collation of the column for any table run following Stored Procedure. EXEC sp_help DatabaseName
Second results set above script will return you collation of database DatabaseName.