DECIMAL

Returns a packed decimal representation of a number or a decimal, integer, or floating-point number represented by a character string.

The first argument must be a number. The second argument is optional and must be in the range of 1 to 31. The third argument is also optional and must be in the range of 0 to p, where p is the second argument. Omitting the third argument implies a specification of 0. Additionally, a character string has a fourth argument that specifies the decimal character. This character must be a period or comma. Use the DECIMAL function in order to force a DECIMAL data type (with a precision of 5 and a scale of 2) to be returned in a select-list for the EDLEVEL column (data type = SMALLINT) in the EMPLOYEE table. The EMPNO column should also appear in the select list.

       SELECT EMPNO, DECIMAL(EDLEVEL,5,2)
         FROM EMPLOYEE