Resource Center : ASP.NET : <How to: SQL 2000, or Express or 2005 Case-sensitivity matches>

How to: SQL 2000, or Express or 2005 Case-sensitivity matches

I found an excellent article which lists many or all possibilities of doing a case-sensitive match in Microsoft sql database engines.

Since we don't need case sensitive matches in our select queries that often, by default all tables in MS SQL servers(2000, SqlExpress, SQL2005) all search for matches insensitive to character case.

But when matching userIDs or passwords or some key information which are case-sensitive, we need to override this default behaviour.

Vyaskn has detailed it in his website.
http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm

Advertisement