MS Access Val() Function
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 |
|---|
