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

CHR ( integer_expression ) 

EXAMPLE

This example illustrates the CHR function and the SUBSTR (substring) function:

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

NOTES

COMPATIBILITY

Progress Extension


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