Rox,
SQL Server doesn't support anything like VFP's Parameterized views. To get the exact same functionality you would have to use a stored procedure.
When you manipulate a view using the SQL DML commands (SELECT, INSERT, UDPATE, and DELETE), SQL Server takes your query and the query that defines the view and combines them together. It then takes this "combined" query and executes it.
-Mike