IsNumeric() mvSQL database function in Jitterbit App Builder

Summary

Determines whether an expression is a valid numeric type.

Syntax

ISNUMERIC( <Expression>)

Parameters

Expression

An expression that is a string type

Returns

int

Returns 1 if Expression is a number, 0 if it is not

Remarks

SQL Server correctly handles E notation and commas in numbers, whereas the other database providers do not.

Examples

ISNUMERIC('-123.45')

Returns

1

ISNUMERIC('123ABC')

Returns

0

ISNUMERIC('X123')

Returns

0