Lists Functions

get_fields_as_string( [fld_delimiter = ',' ], [show_field_names_flag = true], [ field_value_delimiter = '=' ] )

Returns the string that results from concatenating all fields of the tables which take part in the query. Returns NULL if no fields detected. May have one, two or three arguments.

CREATE TABLE t1 ( f1 LONG, f2 String(20) );
INSERT INTO t1 VALUES ( 1, 'abc');

SELECT get_fields_as_string() FROM t1;
=> 'f1=1,f2=abc'
SELECT get_fields_as_string( ':' ) FROM t1;
=> 'f1=1:f2=abc'
SELECT get_fields_as_string( ',', FALSE ) FROM t1;
=> '1,abc'

List_ItemCount ( inList as string [, inDelimiter as string] )

Returns items count in the passed list.

SELECT List_ItemCount( 'a1,b222,c33', ',' );
=>3 

List_NthItem( inList as string, inItemIndex as integer [, inDelimiter as string] )

Returns inItemIndex item from the inList

SELECT List_NthItem( 'a1,b222,c33', 2, ',' );
=> 'b222'