meta data for this page
  •  

F_WORDCOUNT

function from adhoc

Entrypoint wordcount compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(32760)      String in which the amount of words are to be calculated
   Output     INTEGER	            amount of words in the string

Syntax

   A word ends with one ore more spaces, TAB or CRLF.
   TestSQL
   SELECT 4 AS ISCORRECT, F_WORDCOUNT('ABC 123 45678 9123') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_WORDCOUNT(NULL) FROM RDB$DATABASE;