F_FINDWORDINDEX

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

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> 

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