SQL Case Sensitive String Compare

Question

How do you compare strings so that the comparison is true only if the cases of each of the strings are equal as well. For example:

Select * from a_table where attribute = 'k'

...will return a row with an attribute of 'K'. I do not want this behaviour.

Answer 1

You can define attribute as BINARY or use INSTR or STRCMP to perform your search.

Answer 2

Select * from a_table where attribute = 'k' COLLATE Latin1_General_CS_AS 

Did the trick.