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