F_STROFCHAR
<< F_STRREPEAT | IBExpert UDF Functions | F_STRSTUFF U_STRSTUFF >>
F_STROFCHAR
- compatibility to GrUDF
- Compatible with UTF-8
- Input VARCHAR(1) String to repeat, INTEGER Number of repetitions
- Output VARCHAR(32760) Returns a string with the indicated number of repeated indications
Example
SELECT F_STRINGLENGTH(F_STROFCHAR('A', 10)) || ' times A' AS ISCORRECT, F_STROFCHAR('A', 10) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_STROFCHAR =================== ========================================================= 10 times A AAAAAAAAAA
Example
SELECT NULL AS ISCORRECT, F_STROFCHAR(NULL, NULL) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_STROFCHAR ========= ========================================================================== <null> <null>
back to top of page
<< F_STRREPEAT | IBExpert UDF Functions | F_STRSTUFF U_STRSTUFF >>