>>I worry now that this isn't optimized since it's using LIKE (it's now a substring search).
>
>Somebody might call me on this, but I don't think the ODBC driver uses Rushmore anyway.

I hope it does.... I was thinking that it wouldn't take that much to inlude Rushmore since Jet is included in the Access ODBC engine. Of course, that's all speculation on my part.

Also, I when I do my SQL update (see our long thread on 'Am I Misusing Tableupdate?') from VFP remote view to a VFP table, the status bar says 'updated 1 record in 0.00 seconds', only Rushmore says that, right?