List out of a database...

[weee]

Hi There.

I have aling list of cities in a databse. I want to show the list BUT Some of'em repeating themselfs. How can I show the list without showing the same records over and over again?

Thanks!

[russell]

SELECT Distinct city FROM myTable

[weee]

Thank You!