>> Is there is no pure and perfect solution no matter what your proclivity is.

You're absolutely correct. But my original message did state that it was my opinion.

>> A parameterized view is not an ad-hoc query...This type of view can be optimized with SQL Prepare.

From SQL Server's point of view, a VFP view is an ad-hoc query. In fact, you can see this for yourself by starting a trace in SQL Profiler. It's an interesting exercise. If the BatchUpdateCount is set to one, ODBC submits the queries using sp_executesql. If you up the BatchUpdateCount, ODBC uses sp_prepare.

-Mike