I know you can run the check before you submit the info into the DB. You would run the check in the form itself, then once information is true, submit the value into the db table.
I think there is a command called IsNumeric?
so you'd run it like this...
If IsNumeric($value);
Then submit info....
Else
Error
Endif
I know my approach is good, but I'm not sure on the syntax off the top of my head. You might want to do some research...