meta data for this page
  •  

F_STRSTUFF

input/output-compatibility to rFunc (STRSTUFF, LONGSTRSTUFF)

Entrypoint strstuff not compatible with UTF-8 - use U_STRSTUFF

U_STRSTUFF

function from adhoc

Entrypoint u_strstuff compatible with UTF-8

Inputs/Outputs

   Input     CSTRING(8190)      String 1 in which characters had to replace
             SMALLINT           starting-position
             SMALLINT           number of characters to delete
             CSTRING(254)       characters to set
   Output    CSTRING(81900)     String with replaced characters at starting-position

Syntax

   Counting oof starting-position starts at 1.
   The numbers of characters to delete and characters to replace must not be equal.
   TestSQL
   SELECT '12abcd567890' AS ISCORRECT, F_STRSTUFF('1234567890', 3, 2, 'abcd') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_STRSTUFF(NULL, NULL, NULL, NULL) FROM RDB$DATABASE;