IO_Dork
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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'
UPDATE investor set i_email = i_email + ';info@mycompany.com' WHERE taxid='11-1111111'
ASKER