F_RTRIM

<< F_LTRIM (F_LTRIM4, F_LTRIM8) F_BIGLTRIM | IBExpert UDF Functions | F_LRTRIM (F_LRTRIM4, F_LRTRIM8) F_BIGLRTRIM >>

F_RTRIM (F_RTRIM4, F_RTRIM8) F_BIGRTRIM

 
substitutable with TRIM
  • compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF
  • input/output-compatibility to rFunc ( RTRIM, LONGRTRIM)
  • Compatible with UTF-8
  • Input VARCHAR(8190) String whose trailing blanks should be removed
  • Output VARCHAR(8190) String without trailing blanks

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

Example

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

Expected results:

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

Example

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

Expected results:

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

back to top of page
<< F_LTRIM (F_LTRIM4, F_LTRIM8) F_BIGLTRIM | IBExpert UDF Functions | F_LRTRIM (F_LRTRIM4, F_LRTRIM8) F_BIGLRTRIM >>