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

CHAR ( integer_expression ) 

EXAMPLE

This example illustrates the CHAR function:

SELECT *
    FROM  customer
    WHERE SUBSTR (zip, 1, 1) = CHAR (53) ; 

NOTES

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095