F_STRREPEAT
<< F_REPEATTRIM (REPEATTRIM, LONGREPEATTRIM) U_REPEATTRIM | IBExpert UDF Functions | F_STROFCHAR >>
F_STRREPEAT
- input/output-compatibility to rFunc (STRREPEAT, LONGSTRREPEAT)
- Compatible with UTF-8
- Input VARCHAR(254) String to repeat, SMALLINT count of appearance
- Output VARCHAR(8190) String 1 with parameter 2 times appearances
You have to look that the output is not greater than the declaration!
Example
SELECT 'TestTestTest' AS ISCORRECT, F_STRREPEAT('Test', 3) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_STRREPEAT ============ =============================================================================== TestTestTest TestTestTest
Example
SELECT '' AS ISCORRECT, F_STRREPEAT('Test', 0) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_STRREPEAT ========= ===============================================================================
Example
SELECT NULL AS ISCORRECT, F_STRREPEAT(NULL, NULL) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_STRREPEAT ========= =============================================================================== <null> <null>
back to top of page
<< F_REPEATTRIM (REPEATTRIM, LONGREPEATTRIM) U_REPEATTRIM | IBExpert UDF Functions | F_STROFCHAR >>
