Progress
SQL-92
Guide and Reference
CHR Function
Returns a character string with the first character having an ASCII value equal to the argument expression.
SYNTAX
EXAMPLE
This example illustrates the CHR function and the SUBSTR (substring) 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 CHR and CHAR functions are character-set dependent, and support 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
Progress Extension
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |