F_FINDWORDINDEX

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP
Input VARCHAR(32760) String, INTEGER length of the string which should be examined
Output INTEGER examines whether the position from Paramter 2 exists in the string.

If the position is found in the string, the result is the position itself, if not found the result is -1. Counting starts at 0.

Example

 SELECT 5 AS ISCORRECT, F_FINDWORDINDEX('Birthday', 5) FROM RDB$DATABASE;;

Expected results:

    ISCORRECT F_FINDWORDINDEX
 ============ ===============
            5               5

Example

 SELECT -1 AS ISCORRECT, F_FINDWORDINDEX('Birthday', 16) FROM RDB$DATABASE;

Expected results:

    ISCORRECT F_FINDWORDINDEX
 ============ ===============
           -1              -1

Example

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

Expected results:

 ISCORRECT F_FINDWORDINDEX
 ========= ===============
 <null>             <null>

Follow IBExpertise on:

edit SideBar

the database experts