perfect. Obvious really, I should have guessed.

Thanks very much.

Tom

Yikes - don't like the sound of that solution 🙂

Unfortunately it is a requirement, at times, to only search specific columns. The query is constructed dynamically :S

Thanks

Tom

Will this not be incredibly slow? Given that there are approx 20,000 records? And surely the full text search system will run considerably faster using * than separate queries for...

All of them. 🙂

It's a conversion of an existing flat file system where all fields must be searchable.

Thanks

So is there any way around that behaviour? Clearly it's not what's required so why does it work like this?

Thanks

Tom