Peter J. Boettcher — Wed, 26 Apr 2000 13:20:00 +0000

KLWong,

You'll have to setup multiple SQL statements and then use If statements to determine your search.

I don't have time to write the code snippet but I'll try to explain. There are probably many ways to do this, but this is the first one that comes to my mind.

I would HTMLEncode the search phrase, then using the InStr and Mid functions I would search for spaces and separate all the search words into their own strings.

Then depending on what option button they selected (and/or) you can do the select statement.

If you're familiar with the InStr and Mid functions then this should be no problem for you. The challenge will be doing it in a efficient manner, using loops to get the search words, and not manually coding for each separate word.

Hope this helps.

Regards,
Peter J. Boettcher