Re: Partial numeric field update in SQL

[dennis.e.lovelady@xxxxxxxxxxxxx]

Hi, Vern:

I agree that in this particular case, the desired action would be to add
100.  My solution was more of a "how to maniuplate a portion of a numeric
field" example than anything else.  What I wrote is not what I'd have done
in THIS case.

Dennis E. Lovelady





Vern Hamberg <vhamberg@centerfieldtechnology.com>
Sent by: midrange-l-admin@midrange.com
12/11/2002 05:36 PM
Please respond to midrange-l


        To:     midrange-l@midrange.com
        cc:
        Subject:        Re: Partial numeric field update in SQL

Dennis

Result has to be numeric - concatenation is character, so you need to
convert back to numeric. It can be done in recent releases, but why not
keep it simple, as others have suggested? Add 100 * number-of-years

Cheers

Vern

At 12:58 PM 12/11/2002 -0500, you wrote:

>SUBSTR creates a work field.... it's not a pointer into a data record and
>therefore not the kind of thing that you can actually update with the SET
>statement.
>
>What you should be able to do though, is something like this:
>
>UPDATE LIBRARY.FILE
>SET FIELD = SUBSTR(DIGITS(FIELD,1,3)||'3'||SUBSTR(DIGITS(FIELD),5,2)
>WHERE SUBSTR(DIGITS(FIELD),4,1) = '2';
>
>Forgive if my concatenation syntax is incorrect.
>
>HTH
>Dennis


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