hello,
In AS/400 query how do you change an alpha field into a numeric to do math on it?
Example: VARIABLE is defined as an alpha field 4 characters long and has the value ?1234? in it.
I want to add VARIABLE and the field SCORE together to get a sum, what command do I use in query to redefine VARIABLE
as a numeric field?
regards,
Anil.
In AS/400 query how do you change an alpha field into a numeric to do math on it?
Example: VARIABLE is defined as an alpha field 4 characters long and has the value ?1234? in it.
I want to add VARIABLE and the field SCORE together to get a sum, what command do I use in query to redefine VARIABLE
as a numeric field?
regards,
Anil.
Comment