meta data for this page
  •  

F_STRINGLISTITEM

compatibility to GrUDF

Entrypoint stringlistitem compatible with UTF-8

Inputs/Outputs

    Input      CSTRING(32760)      stringlist formatted like ”n=..”,”m=..”, a.s.o.
               CSTRING(254)	     Value from the list to be shown
    Output     CSTRING(1024)	     Searches the string, build a stringlist (Name=Value) for the Name and returns the complete Name=Value

Syntax

   TestSQL
   SELECT '2=gelb' AS ISCORRECT, F_STRINGLISTITEM('"1=blau","2=gelb","3=grün","4=rot"', '2') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_STRINGLISTITEM(NULL, NULL) FROM RDB$DATABASE;