Actually, DISTINCT works for all columns you select (it cannot be applied to only some columns, individually). So, if you want to have different records (different means here: any field can be different), use DISTINCT. If you want only some columns to be distinct, use GROUP BY.

Vlad

>Thanks for the suggestion. It does work. My problem is a little more complex then that. (Where have you heard that before?) We need to Select all the columns(10) and can't do that unless we include them in the Group By and that won't work. But many thanks for responding. Have a nice day.
>
>Regards,
>
>Paige