ASCII()

Scalar. Returns the Unicode code point for a particular character.

Syntax

ASCII( character )

Parameter
character	A character string. The function returns the code point for the first character of this string. If empty or NULL, the function returns NULL.

Data Types
Return	character
Integer	String

Example

The following example determines the Unicode code point of the first character of a column in the stream InStream. Because only the first character is converted, column contents of both D and Dog are converted to 68.

INSERT INTO OutStream
SELECT ASCII(InStream.StringColumn1)
FROM InStream;