MS SQL Server doesn't support parameterized views. The closest thing to it is UDF (SQL 2000 only) that returns a table. See, for example :
- http://www.sqlmag.com/Articles/Index.cfm?ArticleID=15544&pg=2
- http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro2k/html/sql00j9.asp

>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.
>