Tom, The (LISTOF( ...)) function will give you a comma-delimited list. You could then use (ITEMCNT( ...)) to find out if there are more than one items in the list, and, if so, use (SRPL( ...)) to replace the commas with whatever you choose.
Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Eldred Sent: Friday, February 05, 2010 10:41 To: RBASE-L Mailing List Subject: [RBASE-L] - Best Method Question - variables Hi everyone, What would be the best technique to return one, none, or many text values into a single variable that can be separated by hard or carriage returns. Ideally, I would like to incorporate this variable/value into a view for display on a report. I know that: "select committee from cramcommittee where memberend IS NULL and memberidnum = 100039" properly returns the values for member 100039 but, "select committee into vcomserv from cramcommittee where memberend IS NULL and memberidnum = 100039" returns the error too many rows selected if the member belongs to more than one committee. What I hope to accomplish would is: Committee 1 Committee 2 Committee 3, etc... On a report. Thank you for any guidance on this. Tom Eldred Administrative Associate County Road Association of Michigan
