CheckNumeric

The function CheckNumeric() gets a string to be checked for literals as a parameter. The function returns this string if it does not contain any letters. If letters are included, an error message is displayed.

Note: If you do not want to receive an error message but a NULL, please use MakeNumeric.

Syntax:

CheckNumeric('Number/String')

Sample:

CheckNumeric('12345')

returns “12345”

CheckNumeric('12A45')

returns the error message “The CheckNumeric () function failed.

Note: This function is useful to force a task if you want to scrape a numeric value into a database, but it cannot be converted.