Hi Karl,

The format you are looking for can be considered a report. SQL is concerned with fetching data, not display. If you wanted a cursor to look like this, you need to post-process the data.

>Hi everyone, i have a general question about how to get a master list of records. For example, my recordset contains some info as follows:
>
>Name: Applications:
>John Smith Visual Foxpro
>John Smith Microsoft Office
>John Smith Photoshop
>
>I would like use a select statment to return the following info:
>
>John Smith, Visual Foxpro, Microsoft Office, Photoshop
>
>into one record.
>
>Can anyone help me?
>
>Thanx