I am comparing two tables to determine which rows have changed and should be included in a data interface. Changes in capitalization are not being trapped by the EXCEPT clause. The following example does not return any rows when it should return the row from the left table because it is technically different.
Create table #temp3 (name varchar(max))
Create table #temp4 (name varchar(max))
insert into #temp3 Select 'Paul'
insert into #temp4 Select 'PAUL'
Select * from #temp3
Select * from #temp4