MS Access Asc() Function

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP







<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]
-->



MS Access Asc() Function


❮ MS Access Functions



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

❮ MS Access Functions


-