<< F_TAB | IBExpert UDF Functions | F_MID (F_MID4, F_MID8) F_BIGMID U_MID(U_MID4, U_MID8) F_COPY F_STRCOPY >>

F_LEFT

 
substitutable with LEFT

• compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF
• 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 left gives from parameter 2

Counting starts with 1

Example

 SELECT 'This i' AS ISCORRECT, F_LEFT('This is just a test', 6) FROM RDB$DATABASE;

Expected results:

 ========= ============================================
 This i    This i              

Example

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

Expected results:

 ========= ===============================================
 <null>    <null>    

back to top of page
<< F_TAB | IBExpert UDF Functions | F_MID (F_MID4, F_MID8) F_BIGMID U_MID(U_MID4, U_MID8) F_COPY F_STRCOPY >>