>Valerie,
>
>Create a prarmeterized view in the dbc with the WHERE clause of
>
>p1_funckey = ?gcfucntion
>
>Then use this code;
>
>gcfunction = IIF( gcfunction = "001","",gcfunction)
>USE TheView

I tried this, but when gcfunction = "", I get an empty result set instead of all records. Am I doing something wrong here? The sql from my view is:

SELECT *;
 FROM dbo.P1 P1;
 WHERE P1.P1_FUNCKEY = ?gcfunction