SQL Reference Guide

ASCII function (ODBC compatible)

Syntax

ASCII ( char_expression )

Description

The scalar function ASCII returns the ASCII value of the first character of the given character expression.

Example

SELECT ASCII ( zip )

FROM customer ;

Notes

• The argument to the function must be of character type.
• The result is of type INTEGER.
• If the argument char_expression evaluates to null, the result is null.