F_

<< F_LEFT (F_LEFT4, F_LEFT8) F_BIGLEFT U_LEFT(U_LEFT4, U_LEFT8) | IBExpert UDF Functions | F_RIGHT (F_RIGHT4, F_RIGHT8) F_BIGRIGHT U_RIGHT(U_RIGHT4, U_RIGHT8) >>

F_MID (F_MID4, F_MID8) F_BIGMID

 
substitutable with SUBSTRING
  • compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP

F_U_MID (U_MID4, U_MID8)

  • function from adhoc
  • Compatible with UTF-8

F_COPY

  • compatibility to GrUDF

F_STRCOPY

  • input/output-compatibility to rFunc (SUBSTR, LONGSUBSTR)
  • Input VARCHAR(254) String, from which a character string is to be determined, INTEGER Startposition of the string, INTEGER Length of the string
  • Output VARCHAR(254) string starts at position form parameter 2 with the lenght of parameter 3

For F_MID and F_STRCOPY counting of parameter 2 start with 0, for F_COPY with 1!

Example

 SELECT 'day' AS ISCORRECT, F_MID('Birthday party', 5, 3) FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_MID                                                                                                                                                                                                                                 
 =========  =======================================================
 day       day 

Example

 SELECT 'day' AS ISCORRECT, F_COPY('Birthday party', 6, 3) FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_COPY                                                                                                                                                                                                                                
 ========= ============================================================
 day       day 

Example

 SELECT 'day' AS ISCORRECT, F_STRCOPY('Birthday party', 5, 3) FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_STRCOPY                                                                                                                                                                                                                             
 ========= ==================================================================
 day       day 

Example

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

Expected results:

 ISCORRECT F_MID 
 ========= =================================================================
 <null>    <null> 

back to top of page
<< F_LEFT (F_LEFT4, F_LEFT8) F_BIGLEFT U_LEFT(U_LEFT4, U_LEFT8) | IBExpert UDF Functions | F_RIGHT (F_RIGHT4, F_RIGHT8) F_BIGRIGHT U_RIGHT(U_RIGHT4, U_RIGHT8) >>