bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MS Access Asc() Function

Concept visual

MS Access Asc() Function

Pointer walk
two pointers
leftright102132436485116
left=0
right=6
1
3

Start at both ends

Example

Return the ASCII value of the first character in "CustomerName":

SELECT Asc(CustomerName) AS NumCodeOfFirstChar

FROM Customers;

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

Next

Previous

MS Access Functions

Next

MS Access C hr() Function