Need help with search logic

I need my search logic to return results of any checked box on my form. Not just exact matches. my code looks like this. anyone help???<br><br>If (Request.Form("interest1") = "on") Then<br> wherestr = " AND Interest1 = '1'"<br> End If<br> If (Request.Form("interest2") = "on") Then<br> wherestr = wherestr & " AND Interest2 = '1'"<br> End If <br> If (Request.Form("interest3") = "on") Then<br> wherestr = wherestr & " AND Interest3 = '1'"<br> End If <br> If (Request.Form("interest4") = "on") Then<br> wherestr = wherestr & " AND Interest4 = '1'"<br> End If <br> If (Request.Form("interest5") = "on") Then<br> wherestr = wherestr & " AND Interest5 = '1'"<br> End If <br> If (Request.Form("interest6") = "on") Then<br> wherestr = wherestr & " AND Interest6 = '1'"<br> End If <br> If (Request.Form("interest7") = "on") Then<br> wherestr = wherestr & " AND Interest7 = '1'"