Example
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.
Syntax
Val(
string
)Parameter Values
| Parameter | Description |
|---|---|
| string | Required. A string expression |
Technical Details
| Works in: | From Access 2000 |
|---|