Comparar mayúsculas y minúsculas

Declare @var1 varchar(10)
Declare @var2 varchar(10)
set @var1 ='A'
set @var2 ='a'
if ASCII(@var1) = ASCII(@var2)
print 'A and a are treated same'
else
print 'A and a are not same'