Getting Distict Values

I have a table that has a column that has codes like the following

BB
BB
CC
DD
DD
DD

I would like to return just the following using a select:
BB
CC
DD

I know this should be simple, but have no experience.

Also, I would like the results to be returned back in an ADOTable or
ADODataSet. Is this possible? Which is the best one to use?


Thank you,
Tom Woods



.