Numeric to Smallint
>>-SMALLINT--(--numeric-expression--)--------------------------><
String to Smallint
>>-SMALLINT--(--string-expression--)---------------------------><
The SMALLINT function returns a small integer representation of
Numeric to Smallint
The result is the same number that would occur if the argument were assigned to a small integer column or variable. If the whole part of the argument is not within the range of small integers, an error is returned. The fractional part of the argument is truncated.
String to Smallint
If the argument is a string-expression, the result is the same number that would result from CAST( string-expression AS SMALLINT). Leading and trailing blanks are eliminated and the resulting string must conform to the rules for forming a floating-point, integer, or decimal constant. If the whole part of the argument is not within the range of small integers, an error is returned. Any fractional part of the argument is truncated.
The result of the function is a small integer. If the argument can be null, the result can be null. If the argument is null, the result is the null value.
Syntax alternatives: The CAST specification should be used for maximal portability. For more information, see CAST specification.
SELECT SMALLINT(SALARY / EDLEVEL), SALARY, EDLEVEL, EMPNO FROM EMPLOYEE
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.