Hmm, sounds like you are moving down the INTERMEDIA text indexing path. You can concatinate multiple colums into a single intermedia index. Then perform a 'WITHIN' select statment, to return all records which contain the criteria.

Cheers