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
