You are welcome :)
-Stefan
>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