I'm trying to concatenate 2 columns with non-English data and result is showing up as question marks instead of showing the non-English data. I tried casting to nvarchar, but it's not working.
What exactly I'm trying to do:
CAST(SUBSTRING(CONCAT(column A, '--', column B), 0, 255) AS NVARCHAR(255))
I have tried casting the inner columns but result is showing up as question mark! The software I'm using is Denodo VDP, appreciate your the help.
