>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 about:

SELECT Distinct MyField FROM MyTable INTO CURSOR MyCursor

You can also use the GROUP BY clause to limit the occurance of a particular keying sequence:


SELECT MyKey1, MySubKey1,SomeRandomField FROM MyTable GROUP BY MyKey1,MySubKey1 INTO CURSOR MyCursor

>Thanks,
>Elyse