Instead of trimming the last comma off the result, you could prevent the terminal comma from appearing by changing your program slightly.
1) Set the initial value of the variable that will hold the list to the first email 2) In the cursor loop concatenate a comma and the next email address with the list variable Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: June-25-15 4:23 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Last postion Group, I need to run a cursor to get a comma separated list of emails. My solution ends up with a comma in the last position of the TEXT string. How would you trim the last comma off? Jan
