Appending text to fields using Update statement

[Tokhra]

Hey all,

I need to perform an update on a table in my database appending text to fields, something like this:

UPDATE table SET Field1 = Field1 + " Appended Text" etc

So if Field1 was "Hello World" to begin with it will now be "Hello World Appended Text".

Any ideas? I haven't tried that because I don't want to wreck my database by guessing :s

Thanks all,
Matt.

 

[KarveR]

UPDATE table SET Field1 = CONCAT(Field1," Appended Text"); etc

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.