meta data for this page
  •  

F_BLOBTEXTPOS

input/output-compatibility to rFunc (B_TEXTPOS)

Entrypoint b_textpos not compatible with UTF-8 - if needed please ask

Inputs/Outputs

   Input      CSTRING(8190)     String to search in BLOb
              BLOB              BLOb in which is to search
   Output     INTEGER           starting-position of the string in BLOb, 0 if not found

Syntax

   case/uppercase for search-string is not important. Counting for starting-position starts at 1.
   TestSQL (for TestISO.GDB/FDB)
   SELECT 5 AS ISCORRECT, F_BLOBTEXTPOS('zwei', TEXTBLOB) FROM BLOBTEST WHERE BLOBTESTID = 2;
   SELECT 5 AS ISCORRECT, F_BLOBTEXTPOS('Zwei', TEXTBLOB) FROM BLOBTEST WHERE BLOBTESTID = 2;
   SELECT NULL AS ISCORRECT, F_BLOBTEXTPOS(NULL, NULL) FROM BLOBTEST WHERE BLOBTESTID = 2;