Thanks for the reply

No, no other fields apart from the index

The fields are text fields named 'PR1' to 'PR20' which hold a string of text less than 10 characters. Not all are populated but there are thousands of rows. The text I want to search for could be anywhere in the table.

So the current sql I use would be :
'select * from mytable where PR1 = 'mytext' or PR2 = 'mytext' or pr3 = 'mytext' ....etc

I just wondered if there was a way to search the whole table at once?