Try:
Update myTable set myField = concat(myField,' new data to add') where
myField = 'some restrictions';
Regards!
> -Mensaje original-
> De: Rich [mailto:[EMAIL PROTECTED]
> Enviado el: MiƩrcoles, 01 de Noviembre de 2006 06:35 p.m.
> Para: Sub
Hi folks. Boy do I have an interesting one for you today. This list
is great.
Can I update a record using a typical update query, and have a field
be updated to:
previous value of the field + (something I want added to the end)
so field 'flavours' starts out as: "vanilla chocolate"
...t