IS_NUMERIC Function


Function Type

Predefined function

Syntax

IS_NUMERIC( <stringValue> )

Description

Checks a string value and returns "true" if the string contains only numeric characters ('0'-'9').

Argument

Description

<stringValue>

String value to be checked.

A character is a number if it is specified as a number by the Unicode 2.0 standard.

Returns

Boolean

true = String contains only numeric characters.
false = String does not contain only numeric characters.

Example

This example returns "true" since the string value contains only numbers.

IS_NUMERIC("1042")

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI DevX Data Studio Help