ASCII

Description

Returns the number code of a character on the ASCII table (ASCII in Transact-SQL).

Sample Source Pattern

Syntax

ASCII( expression )

Arguments

expression: VARCVHAR or CHAR expression.

Return Type

INT.

Examples

Query

SELECT ASCII('A') AS A , ASCII('a') AS a;

Result

          A|          a|
-----------+ ----------+
         65|         97|