MS Access Val() Function

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

SELECT Val(PostalCode) FROM Customers;

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.

Val(string)

Parameter	Description
string	Required. A string expression

Works in:	From Access 2000