Dear Friends,

I got it right by putting the IF...ELSE condition in the following way.

********************************************************

IF ((@acno IS NOT NULL) AND (@acno ''))

AND ((@actype IS NOT NULL) AND (@actype ''))

BEGIN

PRINT 'both parameters...