RE: Update field concactenation

2006-11-01 Thread Edwin Cruz
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

Update field concactenation

2006-11-01 Thread Rich
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