Hi,

pls. see this code:
DECLARE @SQL nvarchar(4000)
SELECT @SQL = 'SELECT * FROM CUSTOMER WHERE CustomerName = N''Trần Tấn Hận'''
PRINT @SQL

The result is this always:
SELECT * FROM CUSTOMER WHERE CustomerName = N'Tr?n T?n H?n'

How to concatenate strings from a column into a single row (with NULL value)?
xp_cmdshell - works with string in one format but not in another -
Query help
Single to Multiple columns
Assistance with SQL Script