Hello,<BR><BR>I was wondering if there was a way to filter or sort perhaps output of a Do ..... While Loop. I am showing information in a drop down box from a table (named people) in a database. In my State Fields of my various records I have the values:<BR><BR>Texas, Florida, California, Ohio, Florida, Maryland<BR><BR>Here is some example code:<BR><BR><select name="SelectState"><BR><% <BR>Do While Not People.EOF<BR>Response.Write("<option value=""" & _<BR>People("State") & """>" & _<BR>People("State") & "</option>")<BR>People.movenext<BR>Loop<BR>% 2;<BR></select><BR><BR>How do I make it that Florida is shown once and not twice in the drop down box???????<BR><BR>Example code is greatly appreciated.