Expression Engine

These are all the "dBase" style functionss supported by the third party database expression engine used by CD Czar.  While most of these functions are probably not appropriate to CD Czar, the ones that seem like they might be useful in some situations are highlighted in red.  Click here for full description and examples for each, it doesn't mention it but but if you are using the contains() function and are searching on a fragment of a word use the * wildcard character.

ABS() MONTH()
ALLTRIM() NOW()
AT() PAD()
CONTAINS()  PADC()
CHR() PADL()
CTOD() PADR()
CTOT() RAT()
CTOTS() RECNO()
DATE() REVERSE()
DAY() RIGHT()
DELETED() ROUND()
DESCEND() RTRIM()
DTOC() SPACE()
DTOS() STOD()
EMPTY() STOTS()
I2BIN() STR()
IF() STRZERO()
IIF() SUBSTR()
L2BIN()  TIME()
LEFT() TODAY()
LEN() TRANSFORM()
LOWER() TRIM()
LOWERW() UPPER()
LTRIM() UPPERW()
MAX() VAL()
MIN() YEAR()

Here are the Relational operators that are probably the most useful:
=    Equal
!=, <>, # Not equal (you can use either of these)
>    Greater than
>=  Greater than or equal
<    Less than
<=  Less than or equal

And the Logical Operators:
AND  Logically ANDs two operands. If both expressions are True, True is returned. If either expression is False, False is returned.
OR  Logically ORs two operands. If either expression is True, True is returned. If both expressions are False, False is returned.
NOT Unary logical operator that returns the logical inverse of the operand.