Adding Prefixes to existing data

[d170868]

How could I add a prefix to data in a coloumn eg 1S- to the existin
dat

 

[Bas Cost Budde]

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.