meta data for this page
  •  

F_REPEATTRIM

input/output-compatibility to rFunc (REPEATTRIM, LONGREPEATTRIM)

Entrypoint repeattrim not compatible with UTF-8 - use U_REPEATTRIM

U_REPEATTRIM

Entrypoint u_repeattrim compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(8190)     String 1 from which characters will be removed
              CSTRING(1)        character to remove
   Output     CSTRING(8190)     String with removed all repeating's of characters parameter 2

Syntax

   TestSQL
   SELECT '123' AS ISCORRECT, F_REPEATTRIM('12223', '2') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_REPEATTRIM(NULL, NULL) FROM RDB$DATABASE;