database,T-SQL - Riaan's Blog

Browse by Tags

All Tags » database » T-SQL (RSS)
SQL And Case Sensitive queries
Ever wondered how to do a Sql query on case sensitive data, for example passwords? The answer is basically in the collation type. By changing the collation type on the column to SQL_Latin1_General_CP1_CS_AS (Case Sensitive) queries as below will shown will give the required results. Select * from table 1 where password = @password COLLATE SQL_Latin1_General_CP1_CS_AS Subscribe in a reader Join my blog network on Facebook Blog Networks Share this post: email it! | bookmark it! | digg it! | reddit...
Posted 13 August 2008 06:05 AM by riaan | 1 comment(s)
Filed under: , , ,

Search

Go

This Blog

2point-zero

Syndication