Please enable JavaScript to view this site.

 

Function

Description

AND

Logical AND of two (2) or more other conditions

BETWEEN

Determines if a value is greater than one value and less than another value

FLDCHG

Determines whether or not a field has changed by looking at the before and/or after image.

GE

Determines whether a value is greater than or equal to another value

GT

Determines whether a value is greater than another value

ISDEC

Determines whether or not a value is a decimal number

ISINT

Determines whether or not a value is a valid integer

ISNULL

Determines whether or not a value is null

ISNUM

Determines whether or not a value contains valid numeric data

ISTEXT

Determines whether or not a value is a character value

LE

Determines whether a value is less than or equal to another value

LT

Determines whether a value is less than another value

NE

Determines if two values are not equal to each other

NOT

Reverses the result of a Boolean SQData function

ONEOF

Determines whether a particular value is equal to one or more other values

OR

Results of two or more other Boolean functions

WHERE

Specifies filter criteria for source data records