Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

ASCII function [String]

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

ASCII( string-expression )

string-expression    The string.

If the string is empty, then ASCII returns zero. Literal strings must be enclosed in quotes. If the database character set is multibyte and the first character of the parameter string consists of more than one byte, the result is NULL.

• String functions

• SQL/2003    Vendor extension.

The following statement returns the value 90.

SELECT ASCII( 'Z' );