The DIGITS function returns a character-string representation of the absolute value of a number.
If the argument can be null, the result can be null; if the argument is null, the result is the null value.
The result of the function is a fixed-length character string representing the absolute value of the argument without regard to its scale. The result does not include a sign or a decimal point. Instead, it consists exclusively of digits, including, if necessary, leading zeros to fill out the string. The length of the string is:
The CCSID of the character string is the default SBCS CCSID at the current server.
SELECT DISTINCT SUBSTR(DIGITS(INTCOL),1,4) FROM TABLEX
SELECT DIGITS(COLUMNX) FROM TABLEXReturns 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.