I am trying to join two columns with the same information, these columns belongs to a diferents tables (diferent servers).
In first table this column is of type nvarchar(20), in second table is of type varchar(20), i am using the following query to return some rows:
FROM tblEquipaSPI INNER JOIN Colaboradores
ON (tblEquipaSPI.Login COLLATE SQL_Latin1_General_CP1_CI_AS LIKE '%' + Colaboradores.Login + '%')
The problem i have is: when column 1 is equal to column 2 i have a result. But if column 1 have for example "123" and column 2 have "A123" i canno make the join. Note that i have put '%' char.
Can someone tell me what is wrong here?
View Complete Post