The function JRINT can be used in any SQL statement to check numeric values. To do so enter the function name followed by the variable e.g. JRINT(INVOICENUMBER) for a process table field or JRINT[invoicenumber] for a form element. The function ensures that all non-numeric values are removed.
Example:
UPDATE TABLE SET NUMBER = JRINT(invoicenumber) WHERE …
