Christian,

thanks, works like a charm. Unfortunately I did not design this. This is a existing database from which I want to extract some data. Maybe they did this so it 'harder' to extract data from it....

Regards,

Ron

>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