SQL update textfield = textfield + newstring 1

[ddsf]

Hi, I am trying to do the following. I have a text field (a memo field from my point of view , VFP ;-))

I do this in VFP

update table set notes = notes + "string of chars"

It works fine. But the same command to SQL Server, and Sql Server does not like that. It says:

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

How can I do this in SQL Server?

TIA

Don Dodge
ddodge@ncal.verio.com

 

[DLanouette]

First, in SQL Server 2000, Varchars can be upto 8K. changing to Varchars will make your life much easier.

With Text fields, its not as easy as that. Look at READTEXT, WRITETEXT and UPDATETEXT in BooksOnLine.

HTH


______________________________
- David Lanouette
- Lanouette Consulting, LLC
- DLanouette@Computer.org