String Functions

91 functions and 28 Variants

Create Functions - 10 functions

Edit Functions - 45 functions and 19 variants

Convert Functions - 21 functions and 6 variants

Compare Functions - 3 functions

Find/Determine Functions - 12 functions and 3 variant


There are some variants for some functions, f.e. for F_LEFT the variant F_LEFT4 and F_LEFT8.

The variants are only differ in the declaration of the output-string:

F_LEFT → Input CSTRING(254), Output CSTRING (254)

F_LEFT4 → Input CSTRING(4096), Output CSTRING(4096)

F_LEFT8 → Input CSTRING(8190), Output CSTRING(8190)

The variants could be used in one database at the same time but not in one SQL.


returns <null> instead of 0, '' (empty string) or '17.11.1858'

Firebird 1.0 since FireBird 1.0 this function is substitutable with a native SQL statement

Firebird 2.0 since FireBird 2.0 this function is substitutable with a native SQL statement

Firebird 2.1 since FireBird 2.1 this function is substitutable with a native SQL statement

Output RETURN mechanism if nothing other is published: FREE_IT TestSQLs with NULL run only in FireBird 2.