>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
Valerie,
Check your SET EXACT and SET ANSI settings and be sure they are both OFF.