Hello,

you may explicitly cast the column to char datatype e.g:

UnicodeColumn is of type NCHAR(50) in SQL-Server

SELECT CAST(UnicodeColumn AS CHAR(50)) AS UnicodeColumn FROM yourTable ...

if the other table you mentioned is also residing on the SQL-Server, and these 2 columns relate to each other (as you said) then i would redesign the database so they have an equal datatype ..

the hole situation sounds a bit strange though since relating two tables over NCHAR or NVARCHAR datatype is a bit unusual ..

Regards
Christian