Connect CDC SQData

The ISNUM (Is Numeric) function determines whether or not a value contains a valid numeric value. If the value is numeric, a true (1) is returned. Otherwise, a false (0) is returned.

Category

Boolean

Syntax

ISNUM(value)

 

Parameter Descriptions

value  -  This parameter specifies the value to be tested to determine whether or not it is numeric. The value to be tested can be a field from a source datastore, a variable or the result of another Function. 1 | 0 Indicates whether a TRUE (1) or FALSE (0) was returned from the ISNUM function.

Example

Determine whether or not an employee’s bonus field/column (BONUS) within a datastore is numeric. If the field is numeric, map it to the corresponding target field. Otherwise, map a constant of zero (0) to the target BONUS field.

IF ISNUM (BONUS) = 1

{

   TGT_DS.BONUS = BONUS

}

ELSE

{

   TGT_DS.BONUS = '0'

}