SQL Concatenation

28 Apr 2006 3:26 PM

CJEN

What am I doing wrong here?

heat.CallLog.CallDesc + heat.Journal.EntryText AS Expr12

Both of these fields are text fields.

I keep getting this error:

Invalid operator for data type. Operator equals add, type equals text.

Isn't the '+' symbol the operator for concat in SQL Server?

Any help would be appreciated.

28 Apr 2006 3:48 PM

Martin C K Poon

[+ (String Concatenation)] can be used for string concatenation, but it
cannot be applied to image, ntext or text data types.
You can convert your text columns to other data types (char, varchar) first.

Ref.: http://msdn2.microsoft.com/en-us/library/ms177561.aspx

--
Martin C K Poon
Senior Analyst Programmer
====================================

Show quote

"CJEN" <christopher.t.da***@gmail.com> ???
news:1146238010.313636.115160@u72g2000cwu.googlegroups.com ???...
> What am I doing wrong here?
>
> heat.CallLog.CallDesc + heat.Journal.EntryText AS Expr12
>
> Both of these fields are text fields.
>
>
> I keep getting this error:
>
> Invalid operator for data type. Operator equals add, type equals text.
>
>
>
>
> Isn't the '+' symbol the operator for concat in SQL Server?
>
> Any help would be appreciated.
>