How can I update the string contents of two fields in a database into one
field  e.g. FieldA + FieldB into FieldA   without creating a new field using
SQL.

John P

John


If FieldA is big enough then simply

UPDATE table SET FieldA = FieldA + FieldB;
ALTER TABLE table DROP COLUMN FieldB;

If FieldA isn't big enough then you'll need to start the script with

ALTER TABLE table REDEFINE COLUMN FieldA VARCHAR(biggernumber);

purely from memory so test first


Roy Lambert [Team Elevate]