In message <[EMAIL PROTECTED] org>, Charlie Markwick <[EMAIL PROTECTED]> writes >Marius > >Ok, thanks for getting back to me so quickly, that looks interesting. Is >there any way of using directly on an insert statement or would I still >have to select the contents of the field I want to add to first?
UPDATE table SET fieldname=CONCAT( fieldname, 'new bit' ) WHERE recordid=123; -- Pete Clark Sunny Andalucia http://hotcosta.com/Andalucia.Spain
