combine text field with ntext field

select textfield + N'-' + ntextfield as myfield from tbl
results with error
how i can combine text field with ntext field ?
thanksHi
+ is not a valid operator when using ntext. Your result could be 4GB wide,
make sure that it is necessarily to have datatypes this large.
John
"Sam" <focus10@.zahav.net.il> wrote in message
news:uGlE%238buFHA.3792@.TK2MSFTNGP10.phx.gbl...
> select textfield + N'-' + ntextfield as myfield from tbl
> results with error
> how i can combine text field with ntext field ?
> thanks
>|||Hi,
See the old post from Aaron:-
http://groups.google.com/group/micr...c0c3714d2c912a9
Thanks
Hari
SQL Server MVP
"Sam" <focus10@.zahav.net.il> wrote in message
news:uGlE%238buFHA.3792@.TK2MSFTNGP10.phx.gbl...
> select textfield + N'-' + ntextfield as myfield from tbl
> results with error
> how i can combine text field with ntext field ?
> thanks
>sqlsql