I want to use an UPDATE SQL query statement to update the contents of a memo field. So far I have tried using a statement similar to :-

UPDATE <table> SET memofield = memofield + <new data>

This statement does not appear to work with SQL Server and memo (text by SQL Server definition) fields.

Is there another way I can do this without opening a recordset to fetch back the current data?

Appreciate any help on this.