Not sure if you can do this or not. I have a couple of SQL Views. I want to pass the name of the view as a variable from my ASPX to the SP. I'm getting an error that I have to declare the variable @IFV? <BR><BR><BR>This is what I have:<BR>@IFV char(15)<BR><BR>...FROM Customer B,@IFV A LEFT OUTER JOIN ... <BR><BR><BR>I am trying to pass the name of the view I want to run as @IFV and then assign it to name of A. <BR><BR>Is this possible?