James,

look into user-defined functions in SQL Server in SQL Server 2000, they can function as parameterized views. You should be able to create a function that accepts a parameter and returns a table containing results selected from the view, using the parameter in the WHERE clause.

Roman


>I am creating a report in Visual Foxpro 6.0 based on an SQL 2000 view. I would like the view to ask the user for a sales order number and then run the view for just that sales number. Can an SQL view do this?
>
>Thanks
>Jim