Hi:

I have a table (in a MS SQL Sever database) where one of the field is an item number field that is not a unique field. Multiple item numbers are repeated and are scattered all over the table.

I would like to retrieve a record set of 1 each of all the different item numbers.

Can someone show me the SQL syntax to do this?

TIA