declare @a nvarchar(10), @b nvarchar(10)
set @a = 'Abc'
set @b = 'ABC'

if(@a = @b)
	select 'Y'
else
	Select 'N'

if(@a collate Latin1_General_CS_AS = @b collate Latin1_General_CS_AS)
	select 'Y'
else
	Select 'N'

if(@a COLLATE SQL_Latin1_General_CP1_CS_AS = @b COLLATE SQL_Latin1_General_CP1_CS_AS)
	select 'Y'
else
	Select 'N'