This chapter describes the supported syntax elements for calculations, queries, and sort and search specifications. It includes the following topics:

• Operator Precedence
• Comparison Operators
• Logical Operators
• Arithmetic Operators
• About Pattern Matching with LIKE and NOT LIKE
• NULL
• Functions in Calculation Expressions
• Calculated Field Rules
• Calculated Field Values and Field Validation
• Field Object Data Types
• Search Syntax
• Sort Syntax
• About Sorting Versus Searching