Hi

You can do like this too:

Assume Parameters

@a,@B,@C,@D

Select A,B,C,D,*

From Table1

Where A=IsNull(@A,A)

...