APPX Software Library

Chapter 4: SQL Language Elements

4.9.2.4 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 type character.
  • The result is of type INTEGER.
  • If the argument char_expression evaluates to null, the result is null.