>>>I'm doing a SELECT on a file and for one of the columns I want a list of the distinct (character) values for that field. Is there any nice way of doing this?
>>How do you want the result to look?
>>
>>If you just want that field do
>>
>>
select distinct myfield from mytable into cursor cutmp
>
>No, perhaps I wasn't clear. Let's say I have a table that contains customers and items. I want to group it by customer and end up with a file that contains one record per customer where the second field contains a list of the items for that customer.
SELECT DISTINCT Customer + Item AS CustItem ;
FROM mytable ;
INTO blah blah blah
censored.