SQL and repeating values

How can I sort out a SELECT statement to return only 1 instance of a repeating value. For example:

Test
Test
Test
Test
MoreTest
MoreTest
Something
LastOne

SELECT Return = Test, MoreTest, Something, LastOne

Try Select Distinct or Select DistinctRow(MS Access).

Perfect Thanks!