<< F_MID (F_MID4, F_MID8) F_BIGMID U_MID(U_MID4, U_MID8) F_COPY F_STRCOPY | IBExpert UDF Functions | F_SUBSTR (F_SUBSTR4, F_SUBSTR8) F_BIGSUBSTR U_SUBSTR F_STRSUB F_STRPOS >>

F_RIGHT (F_RIGHT4, F_RIGHT8) F_BIGRIGHT

 
substitutable with RIGHT

• compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF

U_RIGHT (U_RIGHT4, U_RIGHT8)

• function from adhoc
• Compatible with UTF-8
• Input VARCHAR(254) String, INTEGER length of the cut-off-string
• Output VARCHAR(254) string cut on the number indication from right gives from parameter 2

Counting starts with 1

Example

 SELECT 'a Test' AS ISCORRECT, F_RIGHT('This is just a Test', 6) FROM RDB$DATABASE;

Expected results:

 ISCORRECT F_RIGHT                                                                                                                                                                                                                               
 ========= =========================================================
 a Test    a Test  

Example

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

Expected results:

 ISCORRECT F_RIGHT                                                                                                                                                                                                                               
 ========= =========================================================
 <null>    <null>  

back to top of page
<< F_MID (F_MID4, F_MID8) F_BIGMID U_MID(U_MID4, U_MID8) F_COPY F_STRCOPY | IBExpert UDF Functions | F_SUBSTR (F_SUBSTR4, F_SUBSTR8) F_BIGSUBSTR U_SUBSTR F_STRSUB F_STRPOS >>