SQL Server's views do not behave the same as VFP's. You can not USE a SQL Server view so there's no reason to store search arguments within the definition.

SQL Server's implementation of views requires that you submit a query against the view. SQL Server will then combine your query and the query that makes up the view to get a "mutant" query, which it then solves.

If you must have something similar to VFP's implementation of view, you can use a function in SQL Server 2000. Functions can return tables which can be used in the table list of a query:

SELECT * FROM ::fn_GetAuthorsInCity('Cincinnati')

See the SQL Server 2000 BOL for more info!

-Mike