You are here: Function Reference > Alphabetical Listing > N > Numeric

Numeric

Use this function to test if a string contains a valid numeric value. The system returns one (1) if the string is a valid number and zero (0) if not.

Syntax

Numeric (String)

Parameter

Description

String

Enter a valid string. The default is the value of the current field.

The system returns true or false depending on whether the string parameter contains a valid numeric value.

Leading or trailing spaces are removed before the string is evaluated. A numeric value contains only numbers, a sign (leading or trailing), and a single decimal point.

Example

Here are some examples:

(Assume the current field value is -101.564)

Function

Result

Explanation

Numeric ( )

1

Defaults to the current field and determines a true statement, such as if the field contains a valid numeric value.

Numeric ("123T456")

0

Determines a false statement, such as if the field does not contain a valid numeric value.

IF Numeric

("4633392")

result = "Yes";

ELSE

result = "No";

END

Return(Result)

"YES"

The specified value is numeric therefore the variable result will be assigned Yes.

 

See also

© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.