Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Joining two text blobs

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-10-30 : 14:49:20
Andrew writes "Hi there, This is probably a stupid question but it doesn't have the answer in SAMs learn SQL in 21 days and yes i am a bit of a newbie at this. I have two text fields and want to make them one. I tried using select Heading2 + LongDesc as H2 from BargainsUpload and got the error
Server: Msg 403, Level 16, State 1, Line 1
Invalid operator for data type. Operator equals add, type equals text. Any help would be appreciated, thanks"
   

- Advertisement -