IsNumeric

Return TRUE if the expression is a valid number, otherwise return FALSE.

Syntax
      IsNumeric(expression)

Key
   expression    A string or numeric expression.

The IsNumeric() function may be used in VBA or in an SQL query.

Examples

Dim boolDemo as Boolean
boolDemo = IsNumeric(123.45)
Returns True
boolDemo = IsNumeric("123.45")
Returns True
boolDemo = IsNumeric("SS64")
Returns False

“Art is the elimination of the unnecessary” ~ Pablo Picasso

Related:

Nz - Detect a NULL value.


© Copyright SS64.com 1999-2014
Some rights reserved