Is there a way to make a where clause in a query (executed from Query Analyzer) case sensitive. For instance, if you wanted to find records based on how people entered a country name:
where country = 'usa'
where country = 'Usa'
where country = 'USA'
Normally, of course, these there queries would produce the same results.