http://www.thebrickhousetestsite.com/search_1.asp

I simplified the code dramatically and it still does not work, it returns no records when the field is left blank

I tried all these and none worked. If it helps, im using "get" on the form and then request.querystring in the sql. I cut and pasted each of the above...