Currently our database is set to case-insensitive so when I search for the word "Math" I can get "MATH" or "Math" and even "math". Now I would like to run a script that searches for any word that is the lower case form such as "math" or "science". Since the collation is set to "I don't care" it will ignore my request of like '[a-z]%' and return the uppercase words. I can also check this by using this script below which compares the same words but in different case:
declare @var1 varchar(4) declare @var2 varchar(4) set @var1 = 'acct' set @var2 = 'ACCT' if @var1 = @var2 print 'match' else print 'no match'
So my question is, is there a way to temporarily set the scope of that script to a case sensative collation for that particular script and not change the server/database collation?