Earn income with your data and sql skills
Sign up and we'll send you the best freelance opportunities straight to your inbox.
We're building the largest self-service freelancing marketplace for people like you.

SQL ASCII Function

The ASCII function returns the ASCII code value for a character.

ASCII stands for American Standard Code for Information Interchange.

ASCII is a 7-bit character set used as the standard encoding for modern computers.

Example

#

This example returns the ASCII values for the given characters.

SELECT ASCII('D') AS 'D',
       ASCII('p') AS 'p',   
       ASCII('9') AS '9',   
       ASCII('½') AS '½',
       ASCII('Ø') AS 'Ø'
Result:  1 record
D p 9 ½ Ø
68 112 57 189 216

Syntax

Syntax of the ASCII function.

ASCII(character)

You may also like



Earn income with your data and sql skills
Sign up and we'll send you the best freelance opportunities straight to your inbox.
We're building the largest self-service freelancing marketplace for people like you.

Guides


vsn 3.1