combine multiple ntext columns into one pre-existing column
Posted on 2004-09-13
Using an SQL query I need to combine several ntext columns into one preexsisting column. Some columns may be NULL.
Table [Community Profile]
Columns [Community Sales Points],[General Notes],[Public Private Elem Secondary],[Colleges Universities],[Outdoor Activities],[Cultural Activities],[Shopping],[Industry],[Restaurant],[Church Denominations],[Health Fitness Ctrs]
I want to combine all columns into the first column [Community Sales Points]. I know this requires using the UPDATETEXT command, but I'm rather confused on the syntax.