This is a list of miscellaneous functions and operators that can be used in TurboSQL.

CONTAINS

Syntax

CONTAINS(full-text-search-expression IN table-name.*)

Description

Evaluates to true, if the row satisfies the full-text search-expression.

NEWGUID

Syntax

NEWGUID

Description

Creates a new Globally Unique Identifier, like for example {2A189230-2041-44A6-87B6-0AFEE240F09E}.

Example

INSERT INTO TABLEA ("Guid") VALUES(NEWGUID)

CURRENTRECORDID

Syntax

CURRENTRECORDID(table_name)

Description

Returns the last used record id of the given table. Using this function, it is possible to enter linked records in multiple tables within one compound statement.

NULLIF

Syntax

NULLIF(value1, value2)

Description

Returns NULL if value1 and value2 are equal and value1 if they are not.

Compatibility Information

This function is only supported in TurboDB Managed.

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