Help w/ SQL statement - no duplicate data.

I have table setup that contains short performance review for multiple people, and for each person, there could be multiple entries listed.

I am making an asp page where you select the person's name, and it will show all of the reviews for that person. Ideally, I would love to have a separate table with the people's name in it and relate it to the reviews, but this is not an option at this time.

What I am looking to do is have a SQL statement that will pull all of the unique names from one column in my table so I can create a dropdown on my asp page for searching....any help?

table name is ticket_eval and column is analyst_name

Thanks!

found my answer the w/ the "DISTINCT" keyword.