How could I add a prefix to data in a coloumn eg 1S- to the existin dat
B Bas Cost Budde Jan 29, 2004 #2 Use an update query. Its SQL could read UPDATE yourTable SET yourField = '1S-' & yourField; this will change all records in the table. If you want to change a certain subset, be sure to add a WHERE clause.
Use an update query. Its SQL could read UPDATE yourTable SET yourField = '1S-' & yourField; this will change all records in the table. If you want to change a certain subset, be sure to add a WHERE clause.
