Can you create a parameterized view in SQL 7.0.

example:

Create View v_Name

@iID int

AS

Select field1 from table where iid = @iID