>>>n1="A15" >>>n2="A"+LTRIM(STR(VAL(SUBSTR(n1,2,2))-1)) &&& gives me n2=A14 >>>>>>tnx
>>n2 = "A" + TRANSFORM(VAL(SUBSTR(n1,2)))
>
>And this keeps working below 10. The trouble with transform() without picture parameter sometimes gives you unexpected result - with decimals etc. If two-digit result is desirable, then I'd rather have
>
>n2 = "A" + TRANSFORM(VAL(SUBSTR(n1,2)), "@L 99")
I don't see how I can change n2 to A14 with this solution.
Borislav's solution enabled me to change the numeric portion of the variable.
k