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