Is there a way to concatenate 2 NText fields using T-SQL?
I’d like to do sometheing like: INSERT Table2 (SELECT NText1 + NText2 from Table1)
The ‘+’ concatenation operator is disallowed for Text and NText datatypes.
I’m using MS SQL Server7.0
TIA