Use the CONCAT() function to achieve this:
UPDATE tmpTable SET Textarea = concat(Textarea,'data you wish to add') WHERE ID
= someID
HTH!
----------------------------------------
From: sam rumaizan <[EMAIL PROTECTED]>
Sent: Thursday, April 05, 2007 12:23 PM
To: [email protected]
Subject: append information
I have a question if you don't mind.
The update statement will replace the existing information. What if I
have Textarea instead and I want to add information to the field
without erasing previous information. Basically append information
---------------------------------
Looking for earth-friendly autos?
Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
