Does anyone know how to compare two columns in SQL Server table that contain Unicode characters.
For eg: When I run this query it works :
select * from ACC_Contact
Title = N'¿¿¿¿'
But when I am trying to query same table by joining two tables based on columns containing unicode characters, the search fails.
This query does not work:
FROM vw_contacts src_cont
JOIN JOIN ACC_Contact stage_cont (NOLOCK) ON LEFT(LTRIM(RTRIM(ISNULL(src_cont.Title, ''))), 50) = stage_cont.Title
AND ISNULL(src_cont.First_Name, '') = stage_cont.FirstName
AND ISNULL(src_cont.Last_Name, '') = stage_cont.LastName
Can you pls tell me how to append N in front of column name, just the way we can do in the first query I mentioned.
Thanks in advance for helping.