Hello everyone,

Using Visual Foxpro, I can create parameterized views such as:

CREATE TestView AS View ;
SELECT Client.Name ;
FROM Client ;
WHERE Client.City=?cCity

In the above example, cCity is a variable. I can then initialize the variable:
cCity="Ottawa"

then Select the query

SELECT * FROM TestView

The ?cCity parameter will have been replaced by the variable's content "Ottawa" and I will obtain all the Client names who's city is Ottawa.

Can something similar be done with Views in Microsoft SQL Server 2000 or is the only way to accomplish this is using a stored procedure?

Thanks for your expertise,


Bruno Di Lalla