THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Asc() Function

❮ MS Access Functions

Example

Return the number code of the first character in "CustomerName":

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

Definition and Usage

The Asc() function returns the number code that represents the specific character.

Syntax

Asc(string)

Parameter Values

Parameter Description
string Required. The character to return the number code for. If more than one character is entered, it will return the value for the first character and ignore all the rest.

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

❮ MS Access Functions