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’)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s