meta data for this page
  •  

F_STRINGCOUNT

function from adhoc

Entrypoint stringcount compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(32760)      String1
              CSTRING(254)        String2
   Output     INTEGER	            Amount of String 2 in String 1

F_RSTRINGCOUNT

input/output-compatibility to rFunc (STRINGCOUNT)

Entrypoint r_stringcount compatible with UTF-8

Inputs/Outputs

   Input     CSTRING(254)       String 1
             CSTRING(32760)     String 2
   Output    INTEGER            Amount of String 1 in String 2

Syntax

   TestSQL
   SELECT 2 AS ISCORRECT, F_STRINGCOUNT( 'ABC 123 45678 9123', '123'), F_RSTRINGCOUNT('123', 'ABC 123 45678 9123') FROM RDB$DATABASE;
   SELECT 0 AS ISCORRECT, F_STRINGCOUNT( 'ABC 123 45678 9123', 'EFG'), F_RSTRINGCOUNT('EFG', 'ABC 123 45678 9123') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_RSTRINGCOUNT(NULL, NULL) FROM RDB$DATABASE;