Skip to main content

[archive] Conversion to Numeric

  • July 30, 2007
  • 1 reply
  • 0 views

[Migrated content. Thread originally posted on 30 July 2007]

Hello
Is there any quick way to convert a zero-suppressed numeric field to a numeric field (ZZZ,ZZ9.99- to S9(6)V99)

Thanks

1 reply

[Migrated content. Thread originally posted on 30 July 2007]

Hello
Is there any quick way to convert a zero-suppressed numeric field to a numeric field (ZZZ,ZZ9.99- to S9(6)V99)

Thanks
If it is a text field going to a numeric field, you can use the CONVERT verb.

MOVE TEXT-FIELD TO NUMERIC-FIELD WITH CONVERT