meta data for this page
  •  

F_MID(F_MID4, F_MID8), F_BIGMID

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP

Entrypoint mid not compatible with UTF-8 - use U_MID(U_MID4, U_MID8)

U_MID(U_MID4, U_MID8)

function from adhoc

Entrypoint u_mid compatible with UTF-8

F_COPY

compatibility to GrUDF

Entrypoint mid1 not compatible with UTF-8 - use U_MID(U_MID4, U_MID8)

F_STRCOPY

input/output-compatibility to rFunc (SUBSTR, LONGSUBSTR)

Entrypoint strcopy not compatible with UTF-8 - use U_MID(U_MID4, U_MID8)

Inputs/Outputs

   Input          CSTRING(254)      String, from which a character string is to be determined
                  INTEGER           Startposition of the string
                  INTEGER           Length of the string
   Output         CSTRING(254)      string starts at position form parameter 2 with the length 
                                    of parameter 3

Syntax

    For F_MID and F_STRCOPY counting of parameter 2 start with 0, for F_COPY with 1!
    TestSQL
    SELECT 'tag' AS ISCORRECT, F_MID('Geburtstagsparty', 7, 3) FROM RDB$DATABASE;
    SELECT 'tag' AS ISCORRECT, F_COPY('Geburtstagsparty', 8, 3) FROM RDB$DATABASE;
    SELECT 'tag' AS ISCORRECT, F_STRCOPY('Geburtstagsparty', 7, 3) FROM RDB$DATABASE;
    SELECT NULL AS ISCORRECT, F_MID(NULL, NULL, NULL) FROM RDB$DATABASE;