ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

ASCII function [String]

Function 

Returns the integer ASCII value of the first byte in a string-expression.

Syntax 

ASCII ( string-expression )

Parameters 

string-expression    The string.

Usage 

If the string is empty, then ASCII returns zero. Literal strings must be enclosed in quotes.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

Example 

The following statement returns the value 90.

SELECT ASCII( 'Z' )