<< F_FINDWORDINDEXN (F_FINDWORDINDEX) | IBExpert UDF Functions | F_STRINGLISTITEM >>

F_STRINGLENGTH(..4, ..8, ..32)

substitutable with CHARACTER_LENGTH or CHAR_LENGTH

• compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF

F_BIGSTRINGLENGTH

• input/output-compatibility to rFunc (STRLEN)

F_STRINGLENGTH (..4, ..8, ..32)

• function from adhoc
• Compatible with UTF-8
• Input VARCHAR(32760) String
• Output INTEGER Determines the length of a string, considers also simple blanks at the end

F_STRINGLENGTH and F_BIGSTRINGLENGTH are not allowed in one SQL.

Example

 SELECT 19 AS ISCORRECT, F_STRINGLENGTH('This is just a Test') FROM RDB$DATABASE;

Expected results:

    ISCORRECT F_STRINGLENGTH
 ============ ==============
           19             19

Example

 SELECT 21 AS ISCORRECT, F_STRINGLENGTH('This is just a Test  ') FROM RDB$DATABASE;

Expected results:

    ISCORRECT F_STRINGLENGTH
 ============ ==============
           21             21

Example

 SELECT NULL AS ISCORRECT, F_STRINGLENGTH(NULL) FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_STRINGLENGTH
 ========= ==============
 <null>            <null>           

back to top of page
<< F_FINDWORDINDEXN (F_FINDWORDINDEX) | IBExpert UDF Functions | F_STRINGLISTITEM >>