Try using the new LISTOF(column_name) function. The link to the syntax is: http://www.rbase.com/rbw65pp/ListOf.htm
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Durham Sent: Monday, July 29, 2002 9:31 AM To: [EMAIL PROTECTED] Subject: Select Question Hi all, I am selecting multiple rows, for example, I have an automated email notification system running. I have more than one email address being inserted into the TO: column of the email. The select command looks something like this: SELECT ename,edomain,edcom, into vnam,vdom,vddcom from emailtable where id = 'l' Now I have more than one email address to insert, so right now I am using a while loop. Is there a shorter way to do this? I would like to select all the names, into one varible, and have a comma between each name. Any help is appreciated. Thanks SD _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
