These are all the "dBase" style functions supported by the third party database 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.  These can be looked up in any standard reference on the dBase language, except perhaps for contains():  As an example, to find all albums with "Best of" in the title use contains(album,"best of"). If you 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.