This shows you the differences between two versions of the page.
— |
char [2015/09/23 20:26] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== CHAR Function - PL/HQL Reference====== | ||
+ | |||
+ | CHAR function converts a number to string. | ||
+ | |||
+ | **Syntax**: | ||
+ | |||
+ | <code language="sql"> | ||
+ | CHAR(num_expression); | ||
+ | </code> | ||
+ | |||
+ | **Return Type:** | ||
+ | |||
+ | STRING | ||
+ | |||
+ | **Example 1:** | ||
+ | |||
+ | <code language="sql"> | ||
+ | CHAR(1000); | ||
+ | -- | ||
+ | 1000 | ||
+ | </code> | ||
+ | |||
+ | **Compatibility**: IBM DB2 | ||
+ | |||
+ | **Version**: PL/HQL 0.03 | ||
+ | |||
+ | See also: | ||
+ | * [[to-char|TO_CHAR Function]] | ||
+ | |||