Searching question

How would someone be able to search through like 1.5 million records looking for a specific piece of text in a field without having to do a linear search through each record, given the fact that they do not have any information about the other fields in the table?

Thanks.

Hege Received on Thu Jan 19 2006 - 13:27:37 CST