ASCII Function in SQL Server: Tips and Examples

The article will learn and guide you how to use the ASCII () function in SQL Server to get the ASCII code of a character.

Describe

ASCII function in SQL Server is used to convert character expressions into ASCII code values ​​of the leftmost character of the expression.

Syntax

To run ASCII function in SQL Server, we use the following syntax:

 ASCII(bieu thuc ky tu) 

Parameters :

• description: the expression returns ASCII code. If you enter more than one character , the ASCII function will return the value of the first character and ignore all the characters behind it .
• ASCII function inverses CHAR function.

ASCII function can only be used in later versions of SQL Server: SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005.

For example

Take a look and explore some examples of ASCII functions in SQL Server.

 SELECT ASCII('q'); 
 Result: 113 
 
 SELECT ASCII('tipsmake.com'); 
 Result: 113 
 
 SELECT ASCII('Q'); 
 Result: 81 
 
 SELECT ASCII('TipsMake.com'); 
 Result: 81 

See also: ASCII encoding and Latin character table ISO 1252

Previous article: FOR loop in SQL Server

Next lesson: Function CHAR in SQL Server