Quotedvaluelist()

Returns a quoted list of all the values, for a given column within the query, delimited by the value given

Usage

STRING = Quotedvaluelist( column, delimiter, defaultreturn )
Argument Summary
column query.column
delimiter value separator. defaults to comma (,) [optional]
defaultreturn if there are no rows, this is the default value return; blank [optional]

Calling

Supports named-parameter calling allowing you to use the function like:

Quotedvaluelist(
   column=?, 
   delimiter=?, 
   defaultreturn=?
);

Supports passing parameters as a structure using ArgumentCollection:

Quotedvaluelist( ArgumentCollection={
   column : ?, 
   delimiter : ?, 
   defaultreturn : ?
} );