Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

Asc

Example

Retrieve the ASCII value of the initial character in the string “CustomerName”.

SELECT Asc(CustomerName) AS NumCodeOfFirstChar
FROM Customers;

Definition and Usage

The Asc() function retrieves the ASCII value of a specified character.

Syntax

Asc(character)

Parameter Values

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.

Technical Details

Works in:

 From Access 2000