THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Val() Function

❮ MS Access Functions

Example

Return the numbers found in a string expression:

SELECT Val(PostalCode) FROM Customers;
Try it Yourself »

Definition and Usage

The Val() function accepts a string as input and returns the numbers found in that string.

Note: This function will stop reading the string once it encounters the first NON-numeric character.

Syntax

Val(string)

Parameter Values

Parameter Description
string Required. A string expression

Technical Details

Works in: Access 2016, Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

❮ MS Access Functions