Thanks for reply,

All-includes all Clients and 999 is just another client and should be treated a bit differently LATER.

999 is just a Client Number and it could be thousands of clients. So I guess, I am sorry I didn't expain it well, the question is how to distinguish between ALL (which is not a Client number but which includes ALL Client Numbers ) and a single Parameter - single Client Number.

Well, I guess I could have written 2 IF statements: One to Select All and the other to select individual CLient Numbers....

Any other comments