SQL Server ASCII() Function
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 |
---|