<< "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... >> SELECT SRPL(LISTOF(Committee), ',', CHAR(10), 0) + INTO vComServ + FROM CramCommittee + WHERE MemberEnd IS NULL AND MemberIDNum = 100039 This assumes the values in column Committee never contain embedded commas (which would split the committee name onto two separate lines). If embedded commas are possible, you need to add two more SRPLs into the expression. You can also do this with a subreport. -- Larry
