DIGITS

Returns a character-string representative of the absolute value of a number. Argument must be an integer or decimal value.

Example:

Assume that COLUMNX has the DECIMAL(6,2) data type, and that one of its values is -6.28.

  DIGITS(COLUMNX)

Returns the value '000628'.

The result is a string of length six (the precision of the column) with leading zeros padding the string out to this length. Neither sign nor decimal point appear in the result.