As Sergey mentions, SQL Server does not implement anything like VFP's parameterized views.

When you query against a SQL Server view, your query and the view's definition are integrated into a single query. You can almost think if it as if SQL Server "inlined" the view definition into your query.

The point is that the SARGs (search arguments) of your query become the parameters that the view uses.

-Mike

>What is the syntax (does it exist?) for setting up view parameters in SQL Server similar to VFP?
>
>P.S. For those of you who would like an exhaustive list of approaches that don't work, please contact me directly.
>
>Paul LaForge
>plaforg@utah.gov