That's it!!! I knew this .... grrrrrrr
THANK YOU Stefan.
>>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