4.3 Concatenation Query

The following example illustrates how to use the SetSeparator function to set the separator to the plus (+) character and then concatenate the values for the Member attribute into one row for GroupNDS objects.

SQL Statement

 SELECT Member_S 
 
 FROM GroupNDS WHERE { fn SetSeparator(’+’) } <>’,’

Enter this statement into the query window, execute the statement, and retrieve the data.

Result Table

The SQL statement will generate a report similar to the following:

Table 4-2 Concatenation Query Result Report

NDS_Name

Member_S

Top Dogs

FJohnson.Fred’s Widgets+GSwift.Fred’s Widgets+ SBrady.Fred’s Widgets