Add data to the left of existing data in Access

T

TLW

I need to add data to multiple records in specific fields but I need to add
it just to the beginning of the field and keep all the existing data that is
already in the field. I know there must be a simple solution....I just don't
know what it is.
 
N

Norman Yuan

Try this SQL UPDATE statement:

UPDATE theTable
SET theField='Newly added data in front of existing' + theField
WHERE <If you need update condition...>
 
Top