> The (magic) word is DISTINCT:
>
>SELECT DISTINCT CityName FROM Customers
>
>will return each CityName in the table Customers once and only once.
>
>Hth
>Imar



That's it!! I knew there was a very simple way of doing it I just couldn't 
remember how. Thank you for your help.