1.1.1

SyntaxExplanation and ExampleOperator
Any other character matches only that character in the
corresponding position in the character expression.
city LIKE 'Sant_'
To treat % or _ as constant characters, escape the character
with an optional escape character, which you specify with the
ESCAPE clause.
SELECT a FROM tabA WHERE a
LIKE '%=_' ESCAPE '='
[ ESCAPE
'
escapeCharacter
']
Note: When LIKE comparisons are used, SQLFire
compares one character at a time for
non-metacharacters. This is different than the way
SQLFire processes = comparisons. The comparisons
with the = operator compare the entire character string
on left side of the = operator with the entire character
string on the right side of the = operator.
Tests whether the first operand is between the second and
third operands. The second operand must be less than the third
operand. Applicable only to types to which <= and >= can be
applied.
WHERE booking_date BETWEEN
BETWEEN
Expression
[ NOT ]
BETWEEN
Expression
DATE('1998-02-26') AND
DATE('1998-03-01')
AND
Expression
{
Operates on table subquery or list of values. Returns TRUE
if the left expression's value is in the result of the table
subquery or in the list of values. Table subquery can return
multiple rows but must return a single column.
WHERE booking_date NOT IN
IN
Expression
[ NOT ]
IN
(SELECT booking_date FROM
TableSubquery
547
SQL Language Reference