TurboSQL Guide

General Functions and Operators

Previous  Top  Next

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.

=

Syntax

expr1 = expr2

Description

Tests for equality.

<

Syntax

expr1 < expr2

Description

Tests whether expression expr1 is lower than expr2.

<=

Syntax

expr1 <= expr2

Description

Tests whether expression expr1 is lower or equal than expr2.

>

Syntax

expr1 > expr2

Description

Tests whether expression expr1 is greater than expr2.

>=

Syntax

expr1 >= expr2

Description

Tests whether expression expr1 is greater or equal than expr2.

BETWEEN ... AND ...

Syntax

expr1 BETWEEN expr2 AND expr3

Description

Tests whether expression expr1 is greater or equal than expr2 and lower or equal than expr3.

IN

Syntax

expr IN (expr1, expr2, expr3, ...)

Description

Tests whether expr is equal to one of the expressions expr1, expr2, expr3, ...

AND

Syntax

cond1 AND cond2

Description

Tests whether both cond1 and cond2 are true.

OR

Syntax

cond1 OR cond2

Description

Tests whether at least one of cond1 and cond2 is true.

NOT

Syntax

NOT cond

Description

Tests whether cond is false.

CASE

Syntax

CASE
WHEN cond1 THEN expr1
WHEN cond2 THEN expr2
...
[ELSE exprN]
END

CASE expr
WHEN exprA1 THEN exprB1
WHEN exprA2 THEN exprB2
...
[ELSE exprBN]
END

Description

The first form of the case operation determines the first expression for which the condition is true. The second one returns the B expression, who's A expression is equal to expr.

Samples

CASE WHEN Age < 8 THEN 'infant'WHEN Age < 18 THEN 'teenager' WHEN Age < 30 THEN 'twen' ELSE 'adult' END
CASE Status WHEN 0 THEN 'OK' WHEN 1 THEN 'WARNING' WHEN 2 THEN 'ERROR' END

CAST

Syntax

CAST(value AS type [COLLATE collation])

Description

Converts the value to the given type if possible. The cast operation may cut off strings and loose precision of decimal numbers. If the conversion is not possible, CAST raises an error.
Casting to string types optionally allows to set a custom sort collation.

Examples

CAST(time AS CHAR(10)) --Converts the time in its string representation
CAST(time AS CHAR(3)) --Displays only the first three characters
CAST(username AS CHAR(50) Collate German_cs_as) --Sets a custom sort collation on field username
CAST(amount AS INTEGER)) --Looses the digits after the decimal point
CAST('abc' AS BIGINT) --Raises a conversion error
CAST(34515 AS BYTE) --Raises an overflow error

See also

General Functions and Operators
Arithmetic Functions and Operators
String Functions and Operators
Date and Time Functions and Operators
Aggregation Functions
Miscellaneous Functions and Operators