jabberwocky ,

Thx for the reply,

But if i have to search based on ACCOUNT and CUSTOMER,
and i am sending an IN parameter, i want the cout to be based on both.

But if Customer is NULL and Account has a value, then i want to exclude that in the count.

But the count is added for NULL as well....

how do i handle this ?