Re: Partial numeric field update in SQL

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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