Case Sensitive SQL Query Search

[Nohim Ys]

Have you ever noticed when you do a string comparison in SQL using '=' notation, case of the string is neglected ???
For example, If TestTable has a TestColumn and it consist of values ‘CaseSearch, casesearch, CASESEARCH, CaSeSeArCh’, following statement will return you all the four records.

SELECT Column1
FROM Table1
WHERE Column1 = 'casesearch'

If you dont want to ignore case and return only the exact row with the specified value, the query should be modified as follows,

SELECT Column1
FROM Table1
WHERE Column1 COLLATE Latin1_General_CS_AS = 'casesearch'

The above change should be done since the default Collation of the SQL Server installation SQL_Latin1_General_CP1_CI_AS is not case sensitive.


Picked this from here - Reference

 

[Mal Baba]

 

[Nohim Ys]

 

[rcccc]

 

[Mal Baba]

Ela Wedak Ban

 

[MihiCherub]

 

[Nohim Ys]

Ela Wedak Ban

 

[Mal Baba]

general_cs_as

 

[Nohim Ys]

general_cs_as

 

[san**]

bmp

 

[luckyluke111]

I can't understand these things machan.. Atleast I haven't try... Bump to move the thread to up..

 

[coolshano]

patta...

 

[Nohim Ys]

bmp

Thx machan

I can't understand these things machan.. Atleast I haven't try... Bump to move the thread to up..

SQL is a software used to create databases machan. Queries are the statements written to manipulate data(Things like Insert,Update,Delete..).
This is something about that software.

Thx a lot for the bump machan

http://www.w3schools.com/sql/default.asp
Just have a glance, if u're interested

 

[luckyluke111]

SQL is a software used to create databases machan. Queries are the statements written to manipulate data(Things like Insert,Update,Delete..).
This is something about that software.

Thx a lot for the bump machan

http://www.w3schools.com/sql/default.asp
Just have a glance, if u're interested

Ela Rep 3+ I'll check this out...

 

[Nohim Ys]

Ela Rep 3+ I'll check this out...

Elaz macho