The VAL() function (common in Natural and similar languages) extracts numeric values from alphanumeric strings by converting them to numeric format, ignoring any trailing non-numeric characters.
The VAL() function converts a string (alphanumeric) representation of a number into its actual numeric value, so it can be used in arithmetic expressions. For example, VAL("123") returns the number 123 rather than the three-character string. This is a standard string-to-number conversion function found in BASIC-family languages.