meta data for this page
  •  

F_BLOBCATSTR

compatibility to GrUDF

Entrypoint blobcatstr not compatible with UTF-8 - use ||

Inputs/Outputs

   Input     BLOB               TextBLOb to join with String from parameter 2
             CSTRING(32760)     String to append to TextBLOb from parameter 1
   Output    BLOB               Joins a TextBLObs and a string to a TextBLOB

Syntax

   This function appends an CRLF and than append the string.
   TestSQL (to use with TestISO.GDB)
   INSERT INTO BLOBTEST (TEXTBLOB) SELECT F_BLOBCATSTR(TEXTBLOB, 'Diese Zeile wurde angehängt') FROM BLOBTEST WHERE BLOBTESTID = 1;
   Insert a new record in table BLOBTEST with the content of the field TEXTBLOB form datarow with ID = 1 append with tthe string ‘Diese Zeile wurde angehängt'