How do would I write a sql query to show me values in value set?

Question

I have a table named tblPhone and I have field in the tabled called Codes that is a value list. How do I write a query in t-sql to shows me whats in the value list. I'm a newbie a t-sql.

Answer 1

Are you saying you have a column called Codes that can have multiple values? If so, that is a HORRIBLE design that is not at all normalized (which makes Dr. Codd cry) and I wouldn't even attempt to develop queries for it.

Answer 2

Select codes from tblPhones group by codes

Answer 3

select codes from tblPhone where ????