<< F_FINDWORDINDEX | IBExpert UDF Functions | F_STRINGLENGTH(..4, ..8, ..32) F_BIGSTRINGLENGTH U_STRINGLENGTH >>

F_FINDWORDINDEXN

• function from adhoc
• 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 <null>. Counting starts at 0.

Example

 SELECT NULL AS ISCORRECT, F_FINDWORDINDEXN('Birthday', 16) FROM RDB$DATABASE;

Expected results:

  ISCORRECT F_FINDWORDINDEXN
 ========= ================
 <null>              <null>

back to top of page
<< F_FINDWORDINDEX | IBExpert UDF Functions | F_STRINGLENGTH(..4, ..8, ..32) F_BIGSTRINGLENGTH U_STRINGLENGTH >>