Val

Example

Retrieve numbers present within a given string and return them.

SELECT Val(PostalCode) FROM Customers;

Definition and Usage

The Val() function processes a string to extract and return the numeric characters it finds, stopping its reading at the first non-numeric character encountered.

Syntax

Val(string)

Parameter Values

Parameter	Description
string	Mandatory. An expression that evaluates to a string is necessary.

Technical Details

WORKS IN

From Access 2000