Is there a way to concatenate more than 2 columns in SELECT statement? When
I try to do the following, I get an error message saying 'Invalid operator
for data type. Operator equals add, type equals ntext.'
SELECT Text1 + Text2 AS Text3
FROM Table1
Is there a SQL function where I can concatenate two columns?
I know I can use regular expressions for computations like
SELECT Price * Tax AS TotalPrice
FROM Table2
and I would think I could do the same thing for text?
Thanks for any help.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
