Loading lesson path
Concept visual
Start at both ends
Check whether the expression is a valid number:
SELECT IsNumeric(1030);The IsNumeric() function checks whether an expression is a valid number. This function returns a Boolean value. TRUE (-1) indicates that the expression is a valid number, and FALSE (0) indicates that the expression is not a valid number.
expression )
Required. The value to test
Return TRUE if the expression is a valid number, otherwise FALSE:
SELECT IsNumeric("Hello");Return TRUE if the expression is a valid number, otherwise FALSE:
SELECT IsNumeric("1030");❮ MS Access Functions