Re: SQL UPDATE

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

update file set field80 = concat(concat(substr(field80,1,27), insert9),
substr(field80, 37))
where.....


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - iSeries Administrator
 -- IBM Certified Specialist - RPG IV Developer

"If you pick up a starving dog and make him prosperous,
  he will not bite you. This is the principal difference
  between a dog and a man."

    - Mark Twain

----- Original Message ----- 
From: "J Michael Smith" <Michael.Smith3@xxxxxxxx>
To: "MIDRANGE-L (E-mail)" <MIDRANGE-L@xxxxxxxxxxxx>
Sent: Thursday, October 30, 2003 13:02
Subject: SQL UPDATE


Is it possible to use the UPDATE function to change the values for a
string(Positions 28-36) within a 80A field?  If so, could you provide an
example.

Thanks.

Michael


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.