THE WORLD'S LARGEST WEB DEVELOPER SITE

SQL Server ASCII() Function

❮ SQL Server Functions

Example

Return the ASCII value of the first character in "CustomerName":

SELECT ASCII(CustomerName) AS NumCodeOfFirstChar
FROM Customers;
Try it Yourself »

Definition and Usage

The ASCII() function returns the ASCII value for the specific character.

Syntax

ASCII(character)

Parameter Values

Parameter Description
character Required. The character to return the ASCII value for. If more than one character is entered, it will only return the value for the first character

Technical Details

Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

❮ SQL Server Functions