What are the benefits of VAL?

What are the benefits of VAL?

And

why is it good for the database ?

and

why is it a security precaution?





for ex



CoID = #Val(CoID)#

What are the benefits of VAL?
VAL makes sure that the entry is a numeric value and returns
a number regards so it can ensure that entries do not conflict with
a DB type definition and throw errors.



Personally, I prefer to validate using IsNumeric, since VAL
could return a value over 0 if the first didgits of the submission
are in fact numeric, but the rest are not.