F_

<< F_STRRM U_STRRM | IBExpert UDF Functions | F_RTRIM (F_RTRIM4, F_RTRIM8) F_BIGRTRIM >>

F_LTRIM (F_LTRIM4, F_LTRIM8) F_BIGLTRIM

 
  • compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF
  • input/output-compatibility to rFunc ( LTRIM, LONGLTRIM)
  • Compatible with UTF-8
  • Input VARCHAR(8190) String whose leeding blanks should be removed
  • Output VARCHAR(8190) String without leeding blanks

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

Example

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

Expected results:

 ISCORRECT           F_LTRIM                                                                                                                                                                                                                     
 =================== =========================================================
 This is just a Test This is just a Test 

Example

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

Expected results:

 ISCORRECT F_LTRIM                                                                                                                                                                                                                               
 ========= ====================================================
 <null>    <null>  

back to top of page
<< F_STRRM U_STRRM | IBExpert UDF Functions | F_RTRIM (F_RTRIM4, F_RTRIM8) F_BIGRTRIM >>