Displaying records, but not identical ones.

[inveni0]

I have a table with several rows. One column is "State", where, of course, a state is listed. I'd like to query the database and list all states in the rows, but I don't want multiple instances of the same state? How can I prevent it from showing:

Mississippi, Texas, Texas, Florida

And instead show:

Mississippi, Texas, Florida

[inveni0]

Holy cow...look at how I spelled "identical".......my I.Q. is above 20...honest...

[edited by: coopster at 2:57 pm (utc) on Jan. 23, 2006]
[edit reason] fixed title spelling;-) [/edit]

[grandpa]

Take a quick look at this article [webmasterworld.com] and see if it helps.

BTW, it's nice to be able to search the forums again in my favorite SE

[inveni0]

That's the ticket! Thanks!