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.