How do I create/allow a drop-down search option for a tinyint variable?

See more:

ASP

VBScript

SQL

drop-down

search

In our database a Lead = 0, whereas a Prospect = 1. I'm trying to make a drop-down where the users can select whether they are searching for a Lead or a Prospect and have it filter out the results.

Will I be formulating some sort of "If, Then" statement?

If "LeadOrProspect" = 0 Then

LeadOrProspect = Lead

Else

LeadOrProspect = Prospect

End If

Would something like that work?

What I have tried:

I've tried mimicking the status drop-down, however, I find that it's not working.

I've also tried using a "getLeadOrProspect" list, but I think that might be useless.

Here is the code that works right now, I'm just trying to find out how I can incorporate a "Lead or Prospect" drop-down.

<td><select size="1" name="OpenClosed" class="small"><option value="0" <%If OpenClosed = 0 Then rw " selected"%>>Open</option><option value="1" <%If OpenClosed = 1 Then rw " selected"%>>Closed</option></td>
                        
<td><input name="name" value="<%=Request("name")%>" class="medium" placeholder="Business Unit or Group Name" /></td>
                        
<td><input name="phone1" value="<%=Request("phone1")%>" class="medium" placeholder="Phone Number" /></td>