DIGITS: Converting a Number to a Character String

How to:

Reference:

Given a number, DIGITS converts it to a character string of the specified length. The format of the field that contains the number must be Integer.


Top of page

x
Syntax: How to Convert a Number to a Character String
DIGITS(number,length)

where:

number

Integer

Is the number to be converted, stored in a field with data type Integer.

length

Integer between 1 and 10

Is the length of the returned character string. If length is longer than the number of digits in the number being converted, the returned value is padded on the left with zeros. If length is shorter than the number of digits in the number being converted, the returned value is truncated on the left.



Example: Converting a Number to a Character String

DIGITS converts the integer expression ID_PRODUCT+1 to a six-character string:

DIGITS(ID_PRODUCT,6)

For the number 1106, the result is the character string '001106'.


Top of page

x
Reference: Usage Notes for DIGITS

iWay Software