>I second your idea. I was just messing around with a table I have with a full-text index on it, but the full-text searches don't ignore the apostrophe. So another field with all punctuation (and white space) stripped out is probably the best solution. Then don't forget to index that field. Too bad we can't index on expressions in SQL like we can in VFP.
Actually just as well. Indexing on expressions in VFP slows things down big time. Try searching on an index using soundex, via an extra field (indexed of course) containing the soundex with even a comparitively small file -- say 30,000 records. The time difference will amaze you. In practice I usually end up creating extra computed fields in VFP rather than using expression in indexes. There are of course exceptions, but normally the savings in significant.
Thanks
Gar W. Lipow