Views

From: ?? (anonymous_at_discussions.microsoft.com)
Date: 10/04/04 

Date: Mon, 4 Oct 2004 03:29:04 -0700

Is it possible to use variables in a view...
Ex: Create view zz as
Declare @user
Set @user = 1
Select * from sometable where @user = 1

i think you get my idea...
Is it possible?