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 |
|---|
Copyright 1999-2023 by Refsnes Data. All Rights Reserved.