You guys are TOO AWESOME.
Never used that command.
Thanks so much,
Dick Fey
Carpet Broker Inc.
On 1/29/2016 10:19 AM, Stephen Markson wrote:
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
--
Dick Fey
Carpet Broker Inc
P: 913-894-9211
F: 913-894-0138
