VistaDB 6
VistaDB / Developer's Guide / SQL Reference / Functions / String Functions / ASCII
In This Topic
ASCII
In This Topic
ASCII(char)

Returns the ASCII code of the first character in the expression.



Example

Returns: 97

Returns: 65

Returns: 65
NOTE: Only the FIRST character is considered for the ASCII operation.  
Use SUBSTRING to get a character from a specific index in a string if required.
SELECT ASCII('A test')
SELECT ASCII('A')
SELECT ASCII('a')

See Also