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