%NumToChar meta-SQL element

Syntax

%NumToChar(Number)

Description

Use the %NumToChar construct to transform a numeric value into a character value. Spaces are trimmed from Number.

Note:

%NumToChar will preserve all trailing zeroes. Therefore, use the scale parameter of %Cast to specify the number of trailing zeroes.

Parameters

Parameter	Description
Number	Specify the number to convert to a character value. Signed numbers, as well as decimals, are acceptable.