Quote:
| Originally Posted by Lazlo Sorry, UPDATE obviously, not INSERT (duh) |
NO, UPDATE DOESN'T WORK FOR NTEXT FIELDS
whoops, sorry
edit: however, moving the table temporarily to SQL2005 and then doing this works...
UPDATE MIGRATION_COMMUNICATION SET COMM_NOTE=RTRIM(COALESCE((CAST(DOCDESC AS VARCHAR(MAX))),'')) + ' '+'-'+' ' +
RTRIM(COALESCE((CAST(MEMO AS VARCHAR(MAX))),'')) FROM MIGRATION_COMMUNICATION