returning one of many

[misterhux]

I have a table with lots of recurring dates in it.. i.e.
8/23/03
8/24/03
8/23/03
8/25/03
8/23/03
8/25/03... etc.

I would like to return from a select statement only one date each.
Date
----
8/23/03
8/24/03
8/25/03

instead right now I get all the dates... is there a way to filter out dates that already have appeared?
thanks in advance.

 

[JamesLean]

SELECT DISTINCT [date]
FROM tbl
ORDER BY [date]

--James

 

[misterhux]

thanks alot