MS Access Asc() Function
Example
Return the ASCII value of the first character in "CustomerName":
SELECT Asc(CustomerName) AS NumCodeOfFirstChar
FROM Customers;
Try it Yourself »
Definition and Usage
The Asc() function returns the ASCII value for the specific character.
Syntax
Asc(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: | From Access 2000 |
---|