F_STRSTUFF
<< F_STROFCHAR | IBExpert UDF Functions | F_PRED U_PRED >>
F_STRSTUFF
substitutable with OVERLAY
- iinput/output-compatibility to rFunc (STRSTUFF, LONGSTRSTUFF)
U_STRSTUFF
- function from adhoc
- Compatible with UTF-8
- Input VARCHAR(8190) String 1 in which characters had to replace, SMALLINT starting-position, SMALLINT number of characters to delete, VARCHAR(254) characters to set
- Output VARCHAR(8190) String with replaced characters at starting-postion
Counting oof starting-position starts at 1. The numbers of characters to delete and characters to replace must not be equal. Example
SELECT '12abcd567890' AS ISCORRECT, F_STRSTUFF('1234567890', 3, 2, 'abcd') FROM RDB$DATABASE;
Expected results:
ISCORRECT F_STRSTUFF ============ =============================================================================== 12abcd567890 12abcd567890
Example
SELECT NULL AS ISCORRECT, F_STRSTUFF(NULL, NULL, NULL, NULL) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_STRSTUFF ========= =============================================================================== <null> <null>
back to top of page
<< F_STROFCHAR | IBExpert UDF Functions | F_PRED U_PRED >>
