I am new to sql and would like your help. I have a table that lists an payroll reference number for all the workers in the business. for example
Emma Davies 01234568
Jo Bloggs 45685214
I need to update the Payroll_reference filed so they all start with EA. So after update is will be
Emma Davies EA01234568
Jo Bloggs EA45685214
I have used this but it did not work. Any ideas please?
set Payroll_ref = 'EA' + 'Payroll_ref'