Re: Help with SQL or ILERPG

[Robert Rogerson <rogersonra@xxxxxxxxx>]

This should work

UPDATE contacts
      SET emailAddress = CONCAT( SUBSTRING( emailAddress, 1, LOCATE( ' @',
emailAddress)), 'newemail.com')

Robert Rogerson

On Thu, Oct 28, 2010 at 4:06 PM, Jack Kingsley <iseriesflorida@xxxxxxxxx>wrote:

> I have a file with a field called contacts.  The contacts field holds
> varying length email addresses.  I want to use the @ as the key to grabbing
> all of the email address content prior to the @ sign and then holding it in
> a variable or ds.  Then I need to add on a new domain name to all of the
> records.
>
> So if I had bob123@xxxxxxxxx    and
>                david67899@xxxxxxxxxxx
>
> I want it to be like this
>
> bob123@xxxxxxxxxxxx
> david67899@xxxxxxxxxxx
>
>
> Could I do this with SQL insert or can I only do this with ILERPG.
>
> Thx.
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.