DIGITS

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-DIGITS--(--expression--)------------------------------------><
 

The DIGITS function returns a character-string representation of the absolute value of a number.

expression
The argument must be an expression that returns a value of a built-in small integer, integer, big integer, decimal, character-string, or graphic-string data type. A string argument is cast to DECIMAL(63,31) before evaluating the function. For more information on converting strings to decimal, see DECIMAL or DEC.

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.

Examples