The type precidence between varchar and nvarchar on your code will upconvert the varchar to an nvarchar during the comparison. It will still work though. It's like you are converting...

thanks for the script. Note to people using it, the CTE doesn't deal with tables from other databases.