Creating a unique list from a database table

JohnD

New to SQL dtabase programming. What is best way to create a unique list from a table. I have a table that contains a column with user names. The problem is there are multipy rows with the same user name. I need to create a list that contains only one of each user name. Guess what I am looking for is to cycle thru the table and extract each user name once.

girishmr

Hmm Though this is not an SQL Forum as such here is what you have to do
Select distinct records from the database and populate it in a drop down list.
[code]
SELECT DISTINCT FROM
WHERE
[/code]

Hope this helps