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 can 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 or Zero Length String.


 
Copyright © 1999-2024 SS64.com
Some rights reserved