You probably need to use & instead of +. Or || if you're on Oracle. -----Original Message----- From: river [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 3:00 PM To: CF-Talk 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
