Link to home
Start Free TrialLog in
Avatar of IO_Dork
IO_DorkFlag for United States of America

asked on

Update field - add data after last character

I know how to use the Update command to update a field with new information, but what if I want to add info to the field after the last character.

For Example, I have a string field were we store email addresses.  I want to update a this field for a bunch of records, but I don't want to overwrite the data, instead I need to add to it at the end of the field.  The existing data for each record will be different, so is important to leave the existing data alone and just add to it.

modifiy the current email field from this:
investor.i_email = me@email.com

to this:
investor.i_email = me@email.com; you@email.com



I know that for updating this field I would use the following command line argument:
UPDATE investor set i_email="you@email.com" WHERE taxid='11-1111111'

My guess is that to add to this field it would be just as simple but with a different command??


Thanks,
Brian
ASKER CERTIFIED SOLUTION
Avatar of Kent Dyer
Kent Dyer
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of IO_Dork

ASKER

Thanks, looks nice and easy.
Avatar of IO_Dork

ASKER

are you sure about that command line...it did not work for me.  Here is what I used:

UPDATE investor set i_email = i_email + ';info@mycompany.com' WHERE taxid='11-1111111'