meta data for this page
  •  

F_BLOBWORDCOUNT

function from adhoc

Entrypoint blobwordcount compatible with UTF-8

Inputs/Outputs

   Input      BLOB        TextBLOb
   Output     INTEGER     No. of words in a TextBLOb

Syntax

   A word ends with one ore more spaces, TAB or CRLF.
   TESTSQL
   SELECT 11 AS ISCORRECT, F_BLOBWORDCOUNT(TEXTBLOB) FROM BLOBTEST WHERE BLOBTESTID = 3;
   SELECT NULL AS ISCORRECT, F_BLOBWORDCOUNT(TEXTBLOB) FROM BLOBTEST WHERE BLOBTESTID = 10;