>Hey John,
> I agree with everything you said. The thing is, can I effect the way ADO creates its where clause when I say "RS.UpdateBatch". It's not really an issue of what the backend supports.


Once again, what ADO can or can't do is determined by the provider. In this case, the provider is really just the VFP ODBC Driver in conjunction with the OLE-DB Provider for ODBC. So, by itself, UpdateBatch does nothing - it needs a provider to "provide" the functionality.

So, I guess the answer is no, I don't think you can affect the where clause.