SQLLesson 413 of 440

MS Access Val() Function

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

reference

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

sql

  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.

text

  Val(string)

Parameter	Description
string	Required. A string expression

Works in:	From Access 2000