F_

<< F_RTRIM (F_RTRIM4, F_RTRIM8) F_BIGRTRIM | IBExpert UDF Functions | F_PADLEFT U_PADLEFT F_RPADLEFT >>

F_LRTRIM (F_LRTRIM4, F_LRTRIM8) F_BIGLRTRIM
  • compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF
  • input/output-compatibility to rFunc (TRIM, LONGTRIM)
  • Compatible with UTF-8
  • Input VARCHAR(8190) String whose leeding and trailing blanks should be removed
  • Output VARCHAR(8190) String without leeding and trailing blanks

Does not remove the protected blanks (with < ALT > < 255 >)

Example 

 SELECT 'This is just a Test' AS ISCORRECT, F_STRINGLENGTH(F_LRTRIM('  This is just a Test   ')) AS LEN, F_LRTRIM('  This is just a Test   ') FROM RDB$DATABASE;

Expected results: 

 ISCORRECT                    LEN F_LRTRIM                                                                                                                                                                                                       
 =================== ============ ==============================================
 This is just a Test           19 This is just a Test

Example 

 SELECT NULL AS ISCORRECT, F_STRINGLENGTH(F_LRTRIM(NULL)) AS LEN, F_LRTRIM(NULL) FROM RDB$DATABASE;

Expected results: 

 ISCORRECT                    LEN F_RTRIM                                                                                                                                                                                                        
 ========= ============ =========================================
 <null>          <null> <null>

back to top of page
<< F_RTRIM (F_RTRIM4, F_RTRIM8) F_BIGRTRIM | IBExpert UDF Functions | F_PADLEFT U_PADLEFT F_RPADLEFT >>