Just wanted to say thanks again to both of you.

Unfortunately, Paul, most of the stuff in your original post is way over my very SQL-challenged head. I'll have to...

Really? Wow, that's a little silly of me then not to have simply tried that before posting here haha.

I genuinely appreciate your help on this and the time you took...

Ok, so here's the code that works in ASP. As you can see, there's a part there where I take the basic query and append additional AND FORMSOF... elements for...

Thanks Barry...much appreciated.

Yes, the code is done and I'll post a modified version of it maybe tomorrow (getting ready to have friends over for dinner and the peppers are almost...

And that was the reason for my post, because, you know, I'm confused.

I have a full-text search that works in an ASP environment that takes whatever's entered into the search...

So are you saying that, for instance if the code doing the search for this example was in ASP.NET, that you'd have to dynamically construct the SQL statement within that...