Data Management - Latest Comments on SQL Advent 2012 Day 3: Sargable Queries http://blogs.lessthandot.com/index.php/DataMgmt/?disp=comments en-GB http://backend.userland.com/rss 60 SQLDenis [Member] in response to: SQL Advent 2012 Day 3: Sargable Queries Tue, 04 Dec 2012 13:55:49 +0000 SQLDenis [Member] c11235@http://blogs.lessthandot.com/ Liviu, I don't understand your point, if they are all case sensitive then this should still return the same 1 row http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/sargable-queries#c11235 liviu [Visitor] in response to: SQL Advent 2012 Day 3: Sargable Queries Tue, 04 Dec 2012 13:46:43 +0000 liviu [Visitor] c11234@http://blogs.lessthandot.com/ What about the situation where the server and database all have case sensitive collations.<br /> <br /> The trick with:<br /> SELECT * FROM CaseSensitiveSearch<br /> WHERE Val = 'ABCD' COLLATE SQL_Latin1_General_CP1_CS_AS<br /> AND Val LIKE 'ABCD'<br /> <br /> will not work anymore because<br /> <br /> 'abcd' LIKE 'ABCD' is false...<br />
The trick with:
SELECT * FROM CaseSensitiveSearch
WHERE Val = 'ABCD' COLLATE SQL_Latin1_General_CP1_CS_AS
AND Val LIKE 'ABCD'

will not work anymore because

'abcd' LIKE 'ABCD' is false...
]]> http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/sargable-queries#c11234