What Event Rule Function can I use to keep leading zeros when moving Numeric to String?

ACEMAN

Member
What Event Rule Function can I use to keep leading zeros when moving Numeric to String?

A good example of what I need to do is like storing F4211.DOCO in F4211.OORN (Where DOCO is numeric and OORN is an alpha string). In coding ER's, when I assign OORN = DOCO I get a left justified zero-suppresed value; this is not what is needed. If DOCO is 109559 I need OORN to result in 00109559. I have tried SUBSTR and LPAD but nothing seems to work. HELP, anyone!

Thanks.
D. Scott
 
Re: What Event Rule Function can I use to keep leading zeros when moving Numeric to String?

OORN = lpad([DOCO], '0', 8)
 
Back
Top