ASP+ACCESS makes multiple fuzzy queries for help!

Several fuzzy searches will be judged item by item to form an SQL statement. Let me tell you something:

Sql="select * from table name, where 1= 1 "

If trim (request (whether the first search condition is empty)) <> ""Then

SQL = SQL&"and field 1 similar'"&; Keyword 1& "'"

If ... it will be over.

If trim (request (whether the second search condition is empty)) <> ""Then

SQL = SQL&"and field 2 are similar to'"&; Keywords 2& "'"

If ... it will be over.

And so on, the final code is as follows:

Connecticut, 1, 1

Then do it. I wonder if my answer will help you.