qinformation
asked on
SQL EXCEPT not recognizing differences in capitalization
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
EXCEPT
Select * from #temp4
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Been doing this for years and years but never had to deal with collation until now. Always learning!
Wait until you have to study for Microsoft exams, you learn all sorts of goofy cr*p you never had to deal with before.
Thanks for the grade. Good luck with your project. -Jim
Thanks for the grade. Good luck with your project. -Jim
ASKER