Progress
SQL-92
Guide and Reference
CHAR Function
Returns a character string with the first character having an ASCII value equal to the argument expression. CHAR is identical to CHR but provides ODBC-compatible syntax.
SYNTAX
EXAMPLE
This example illustrates the CHAR function:
NOTES
- The argument to the function must be of type INTEGER, TINYINT, or SMALLINT.
- The result is of type CHARACTER.
- If the argument
integer_expression
evaluates to null, the result is null.- The CHAR and CHR functions are character-set dependent, and support single-byte and multi-byte characters. If
integer_expression
is a valid character encoding integer value in the current SQL server character set, the function returns the correct character. If it is not a valid character the function returns a NULL value.COMPATIBILITY
ODBC Compatible
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |