1.1.1

SyntaxExplanation and ExampleOperator
Expression
-- returns true
|
Expression
OR
Expression
|
NOT
Expression
}
<, =, >, <=, >=, <> are applicable to all of the built-in types.
DATE('1998-02-26') <
Comparisons
Expression
DATE('1998-03-01')
-- returns true
{
< |
= |
> |
<= |
>= |
<>
}
Expression
Test whether the result of an expression is null or not.
WHERE MiddleName IS NULL
IS NULL, IS NOT NULL
Expression
IS [ NOT ]
NULL
Attempts to match a character expression to a character
pattern, which is a character string that includes one or more
wildcards.
% matches any number (zero or more) of characters in the
corresponding position in first character expression.
LIKE
CharacterExpression
[ NOT ] LIKE
_ matches one character in the corresponding position in the
character expression.
CharacterExpression
WithWildCard
vFabric SQLFire User's Guide546
vFabric SQLFire Reference