Neoview SQL Reference Manual (R2.2)

CHAR Function
The CHAR function returns the character that has the specified code value, which must be of
exact numeric with scale 0.
CHAR is a Neoview SQL extension.
CHAR(code-value, [,char-set-name])
code-value
is a valid code value in the character set in use.
char-set-name
can be ISO88591 or UCS2. The returned character will be associated with the character set
specified by char-set-name with the DEFAULT collation.
The default is ISO88591.
Example of CHAR
Select the column CUSTNAME and return the ASCII code of the first character of the customer
name and its CHAR value:
SELECT custname, ASCII (custname), CHAR (ASCII (custname))
FROM sales.customer;
CUSTNAME (EXPR) (EXPR)
------------------ ------- -------
CENTRAL UNIVERSITY 67 C
BROWN MEDICAL CO 66 B
STEVENS SUPPLY 83 S
PREMIER INSURANCE 80 P
... ... ...
--- 15 row(s) selected.
CHAR Function 301