Miscellaneous Functions and Operators

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.*)
CONTAINS(full-text-search-expression IN column-name1, column-name2, column-name3, ...)

Description

Evaluates to true, if the row satisfies the full-text search-expression. In the second variant, the full-text search-expression must be satisfied on the given column subset.

Example

If you are searching for a row where the word 'computer' is contained both in the column Category and in the column Name, you write:

SELECT * FROM Devices WHERE CONTAINS('computer' IN Category) AND CONTAINS('computer' IN Name)

Compatibility Information

The second variant is only available in TurboDB Win.

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.