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