>Did you use the VFP view designer? It uses that syntax when creating remote views with the sql server driver.

It's possible, but I don't think so. We started with a local DBC that we upsized, but that view was made after upsizing, when we didn't use the view designer anymore. Besides, the VD is unable to correctly make that query. As far as I can remember, I hand-typed that view manually - that's what bugs me the most! :)

No other view, including those I'm sure were made in the VD has that - although all the views made with the VD were first made for the local DBC and later modified to work well with SQLServer.

Thanks for the info!