Retrieve the ASCII value of the initial character in the string “CustomerName”.
| SELECT Asc(CustomerName) AS NumCodeOfFirstChar FROM Customers; |
The Asc() function retrieves the ASCII value of a specified character.
| Asc(character) |
|
Parameter |
Description |
|
character |
Mandatory. Specifies the character for which the ASCII value is returned. If multiple characters are provided, only the ASCII value of the first character is returned. |
|
Works in: |
From Access 2000 |