Case sensitive search in SQL

Hi,

By default SQL query is case-insensitive, so if I query for ‘Finish’ I get both ‘Finish’ and ‘finish’ (and it could also include ‘FINISH’, ‘fiNish’ and so on).

In order to get only the case you wand use:

WHERE <field_name> COLLATE Latin1_General_CS_AS = ‘Finish’)