F_

<< F_LRTRIM (F_LRTRIM4, F_LRTRIM8) F_BIGLRTRIM | IBExpert UDF Functions | F_PADRIGHT U_PADRIGHT F_RPADRIGHT >>

F_PADLEFT U_PADLEFT

 
substitutable with LPAD
  • compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF

U_PADLEFT

  • function from adhoc
  • Compatible with UTF-8
  • Input VARCHAR(4095) String 1, filled up left with the indications from string 2 to the length of parameter 3, VARCHAR(16) String 2 to fill up with, INTEGER Length of the string, up to which is to be filled up
  • Output VARCHAR(4095) String 1 left filled up from the string with the indications from string 2 to the overall length of indications of parameter 3

F_RPADLEFT

  • input/output-compatibility to rFunc (PADLEFT, LONGPADLEFT)
  • Input VARCHAR(4095) String 1, filled up left with the indications from string 2 to the length of parameter 3, INTEGER Length of the string, up to which is to be filled up, VARCHAR(16) String 2 to fill up with
  • Output VARCHAR(4095) String 1 left filled up from the string with the indications from string 2 to the overall length of indications of parameter 3

If you enter more than one character in string 2, the filling with characters of string 2 starts from right and abort, if the required number of the complete characters will be reached.

Example

 SELECT 'XXXThis is just a Test' AS ISCORRECT, F_PADLEFT('This is just a Test', 'X', 22) FROM RDB$DATABASE;

Expected results:

 ISCORRECT              F_PADLEFT
 ====================== ====================================================
 XXXThis is just a Test XXXThis is just a Test

Example

 SELECT 'xXxThis is just a Test' AS ISCORRECT, F_PADLEFT('This is just a Test', 'Xx', 22) FROM RDB$DATABASE;

Expected results:

 ISCORRECT              F_PADLEFT                                                                                                                                                                                                       
 ====================== ====================================================
 xXxThis is just a Test XxXThis is just a Test  

Example

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

Expected results:

 ISCORRECT              F_PADLEFT                                                                                                                                                                                                       
 ====================== ====================================================
 <null>    <null>  

back to top of page
<< F_LRTRIM (F_LRTRIM4, F_LRTRIM8) F_BIGLRTRIM | IBExpert UDF Functions | F_PADRIGHT U_PADRIGHT F_RPADRIGHT >>