[dba-SQLServer] Views With Parameters ?

To all,
Is it possible to create a parameter type view in SQL Server 7.0, which I can then call from Visual Basic 6.  Something like SELECT * FROM tblPersonnel WHERE tblPersonnel.PayrollNo = ?   and then in VB something like rsPerson.Open("Query '" & Me.PayrollNo & "'"),OpenSQLConn   etc etc
Paul Hartland

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm