>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?
You can probably use "Distinct":
Select Distinct yourField From yourTable;
hth
-Stefan