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.

Accepted Answer

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

Did the trick.

SQL Case Sensitive String Compare

Solution

Problem