You may have to use the & as the concatenation operator, depending on the
RDBMS being used.
DC
----- Original Message -----
From: "river" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 10:00
Subject: Concatenating ntext in SQL SELECT statement
> 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
