RE: Substring in SQL update

[Bruce Guetzkow <bguetzkow@xxxxxxxxxxxxx>]

Using "substr" to update in SQL is a breeze.  Although we are currently at 
V3R7, I'm sure I've
done it at earlier releases.

UPDATE library/file
SET field1 = substr(field2,start,length)   -- length is an optional parameter

hth
--Bruce

----------
From:   Jim Ackerman[SMTP:packley@voicenet.com]
Sent:   Monday, November 17, 1997 6:32 PM
To:     Midrange Systems Mailing List
Subject:        Substring in SQL update

Is there a way to use substr when updating with SQL (at v2r3m0 -- we're
a tad behind the times yet)?  The manual tells how to select using
substr, but not to update or set.

Thanks in advance!
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---