Update field - add data after last character

Posted on 2012-09-09
Last Modified: 2012-09-10
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 =

to this:
investor.i_email =;

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

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

Question by:IO_Dork
    LVL 17

    Accepted Solution

    Should be a simple matter of running a SQL Update..
    SET investor.i_email = investor.i_email + ';'

    Open in new window



    Author Closing Comment

    Thanks, looks nice and easy.

    Author Comment

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

    UPDATE investor set i_email = i_email + ';' WHERE taxid='11-1111111'

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: (http://msd…
    For Sennheiser, comfort, quality and security are high priority areas. This paper addresses the security of Bluetooth technology and the supplementary security that Sennheiser’s Contact Center and Office (CC&O) headsets provide.  
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now