I'm doing the book worm thing with getting the feel for SQL Server 7, and I've recently tackled the topic of Views. I'm seeing examples where the underlying SELECT statement has a WHERE clause, but I havent seen examples with a variable or parameterized WHERE clause (I see none of those little @ thingys, hmmmm....)

So is it possible with a View in SQL Server to do what I'm used to doing in VFP with parameterized local views? Or am I way off base here? If I can not use a varable or parameter with a view, what would I do in SQL Server to get a result set based on a variable who's value is set at runtime? TIA!