Is is possible to create parametrized views in SQL Server 7.0? I'm doing a huge join of tables as a view but only need a subset of it at run time. In other words the WHERE clause has a variable that is not decided until runtime. Is there a way to define the view that takes a variable in the WHERE clause?

As a simple example, is it possible to do something like this:
CREATE VIEW myView
AS
SELECT a,b,c,d
FROM tbl1 INNER JOIN tbl2 ON tbl1.col1=tbl2.col1
WHERE tbl1.y4mm=@userSpecified