SQLTeam.com Logo

Return to Case sensitive queries

Case sensitive queries

Written by Bill Graziano on 21 June 2002

LarynX submitted "in a reply to a question asked by the reader eric about case sensitive searching in sql ->
http://www.4guysfromrolla.com/webtech/sqlguru/q022400-1.shtml

the sql guru gave him a few solutions but all had serious downfalls (as stated by the guru), in the above url is a solution from microsoft...

it works perfectly on all sql server versions but is not required on sql server 2K thanks to data collation that can be specified down to the cloumn level (also stated in the url)"