I didnt develop this code. I want to modify the last line.
The promodsc will be a negative number with decimal value. I want to eliminate the sign and decimal. For example promodsc is -4.99. I want it change to 499. The rest of command will give me 0000000499+ string I need. What do I need to change here?
REPLACE TAX_AMT WITH RIGHT("0000000000" + ALLTRIM(B->TAXTOTAL),10) + "+"
REPLACE FRT WITH RIGHT("0000000000" + ALLTRIM(B->SHIPTOTAL),10) + "+"
REPLACE BPAY_TYP WITH "04"
REPLACE DISC_AMT WITH RIGHT("0000000000" + ALLTRIM(b->promodsc),10) + "+"
Our community of experts have been thoroughly vetted for their expertise and industry experience.