get all values

[GO ILLINI]

Is it possible to just return all the values that are in a column?

-Adam

[shyam]

select column_name from table_name;

or am i missing something here...

[guelphdad]

if you mean to only list the unique/distinct values, and not return duplicates do the following

SELECT DISTINCT columnname
FROM yourtable

[GO ILLINI]

DISTINCT was what i was looking for. Thanks.