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/
