Hi Kevin,

   SELECT DISTINCT field1 ;
       FROM mytable ;
       INTO mycursor

Hope this helps,
Gavin...

>I have a table in which some records are duplicate.
>
>How do I select out only one of each record?
>
>Thanks