SQL ASCII

SQL ASCII function is used to return ASCII code of a character, if the parameter is a string, it will return the ASCII code of the most left character.

SQL ASCII Function Syntax

ASCII(character-expression)

SQL ASCII Function Example

SELECT ASCII('S') -- Value: 83

SELECT ASCII('Q') -- Value: 81

SELECT ASCII('L') -- Value: 76

SELECT ASCII('-') -- Value: 45

SELECT ASCII('Statements') -- Value: 83

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>