I'm trying to take data from varchar fields in one table and copy it to Nvarchar fields in another table. (Long story - now dealing with multiple languages, not enough space in row in current table for multiple Nvarchar fields...).
I know how to insert new text into the Nvarchar fields:
Code:
INSERT INTO tblNotes ( noteID, note ) SELECT 1, N'This is a unicode note'