There is a list of functions and operators that can be used within TurboSQL expressions. This list is composed of a few standard SQL functions and a lot more additional TurboDB functions.
Operators
| +, -, *, /, || | Have the usual meaning |
| AND, OR, NOT | Have the usual meaning |
| LIKE, NOT LIKE | Have the usual meaning |
| IN [...], NOT IN [...] | Have the usual meaning |
SQL Full-Text Predicates and Functions
| CONTAINS(full-text-search-expression IN table-name.*) | Evaluates to true, if the row satisfies the full-text search-expression |
SQL Standard Functions
| ATAN(value) | Calculates the arcus tangens of value |
| AVG(value) | Calculates the average of the values in the column |
| CASE...WHEN...THEN... | Calculates value according to a list of conditions |
| CAST(value AS type) | Converts the value to the given type if possible |
| COS(value) | Calculates the cosine of value |
| COUNT(value) | Calculates the number of rows in the column |
| EXP(value) | Calculates the exponential of value (to base e) |
| EXTRACT(kind FROM date) | Calculates a value from date. Kind is one of DAY, WEEKDAYNAME, WEEK, MONTH, YEAR, HOUR, MINUTE, SECOND |
| LEN(string) | Returns the length of the string |
| LOWER(string) | Returns the string in lower case |
| MAX(value) | Calculates the maximum of the values in the column |
| MIN(value) | Calculates the minimum of the values in the column |
| SIN(value) | Calculates the sine of value |
| SQRT(value) | Calculates the square root of value |
| SUM(value) | Calculates the sum of the values in the column |
| SUBSTRING(string FROM start [FOR length]) | Returns a partial string of length length from string starting at start |
| TRIM([[kind] [char] FROM] string) | Returns a string without leading or trailing characters. Kind is one of LEADING, TRAILING, BOTH. |
| UPPER(string) | Returns the string in upper case |
Additional TurboDB Functions
See "TurboDB Concepts/Operators and Functions"