THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Val() Function

❮ MS Access Functions

Example

Read a string and return the numbers found in the string:

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

Definition and Usage

The Val() function reads a string and returns the numbers found in the string.

Note: This function stops reading once it encounters a NON-numeric character.

Syntax

Val(string)

Parameter Values

Parameter Description
string Required. A string expression

Technical Details

Works in: From Access 2000

❮ MS Access Functions