Or (preferred) SELECT LISTOF(colname) INTO var INDICATOR vind FROM…
Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: January-29-16 11:03 AM To: Stephen Markson Subject: [RBASE-L] - Re: Crazy need Can you use the LISTOF command? something like SET VAR vString = (LISTOF(columnname)) FROM table WHERE ..... Karen -----Original Message----- From: Carpet Broker, Dick Fey <[email protected]<mailto:[email protected]>> To: karentellef <[email protected]<mailto:[email protected]>> Sent: Fri, Jan 29, 2016 9:46 am Subject: [RBASE-L] - Crazy need I need to take information from multiple rows in a table, concatenate them into one string. These are carpet cuts that I need to put in an order. Table 10-3 16-9 22-6 They are already text. I want "10-3, 16--9, 22-6" in 1 text string. Each row has a unique identifier. Perhaps load each row in a variable, then build my string ? -- Dick Fey Carpet Broker Inc P: 913-894-9211 F: 913-894-0138
