> 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?
SQL Server limits what you can do with text and ntext field types
You can convert them, but this tends to trim;
select convert(varchar(4096),text1)+convert(varchar(4096),text2) as text3
from table1
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
