Unique Value Returns

[DrunkenEngineer]

I need to build a menu showing all the unique entries in a certain table field. The table lists part vendors, and I need to create a simple listing of all the vendors we deal with, but the table can have 100-200 parts all manufactured by the same vendor, therefore appearing in the table 100-200 times.

Is there a way to look through the table, and pick out all the unique vendor names? (ie. If a vendor is shown many times, only display it once in the list?)

 

[jjonesal]

SELECT DISTINCT vendorname FROM tablename

The DISTINCT keyword can be used to eliminate duplicates.

Hope this helps... J. Jones
jjones@cybrtyme.com