Ben - It's my favorite function! I use it in forms & reports instead of creating views with UNION SELECTs whenever I can.
Sami ----- Original Message ----- From: "Ben Petersen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 10, 2002 7:54 AM Subject: Re: More from select distinct than I can probably expect but here goes: > Now THAT is the coolest use of "listof" I've seen yet! Good catch! > > Ben Petersen > > On 10 Dec 2002, at 14:22, Sami Aaron wrote: > ..... > > or even better, > > SELECT RiderNum,Fname,Lname,(LISTOF(RideMiles)) FROM Rides + > > WHERE GroupNumber = 8 + > > GROUP BY RiderNum,Fname,Lname > > > > Sami > > ================================================ > 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/
