SQL NText field concatenation? - TechRepublic
General discussion
July 3, 2001 at 08:45 AM
andrew

SQL NText field concatenation?

by andrew . Updated 24 years, 12 months ago

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

This discussion is locked

All Comments