cascading parameters

Hi

I have three params p1 , p2 and p3.

All 3 are non queried with values Yes and NO .

if p1 is yes only i have to enable the remaining twp params otherwise disable them.

Can some one suggest as to how this can be achieved.

Thanks

You could:

1) Create a function that takes care of it using a switch statement and passes the correct information to the database.

2) Create a stored procedure that uses a case statement.