Alvin,

SQL Server does not anything similiar to VFP's parameterized views. Nor does it need it. When you reference a view in a query, SQL Server takes the views definition and your query and merges them together. It then runs the resultant query. So any search arguments that you specify in your query make it into the view.

-Mike