I think its easy anyway.... Im doing a search form.. finding people by location and ame. Name is a text field, location is a drop down. I want an option of "Any" in location.. I.e, send no information to the asp page, ok? But if you leave the value of the "any" option empty, it submits the value as "any". How do i stop this? The text field is ok... if you leave it blank then it sumits no information.

If you set the value of 'Any' in the drop-down to the "%" wildcard, it should work. Basically, you're telling the Server to retrieve all values for this field.

One more thing... when you use the "%" as the wildcard.. you must also use the qualifier of LIKE and not =

Wm. Kent Steelman

Thanks guys, thats got it.