Creating a concatenated search field and using the full-text index on that certainly worked. Is that my only alternative? I probably could make that work...

Well, yes, I could get it that way. But I'm using WHERE CONTAINS because this is a site search. Other than this one sticky problem, it is much more powerful...

I gave that a shot (specifying the field names), but I still don't get any records returned. I assume that SQL is thinking to compare my search phrase ("Honda" AND...