Important: This section provides some guidance when working with Search Formula. It is assumed that you are familiar with the implementation of SQL expressions.
- Text in single quotes
- Use || (double pipes) to concatenate
- Standard operators (+, -, /, *) to calculate
- No commas in numbers
- Enclose calculations in parentheses when concatenated with strings