Thank-you AJ,

I will try what you suggested. I was not aware that there is a functionality like this: 'TOP'.

I will let you know if it helped me.

Regards.

Hello AJ,

Thank-you for the reply.

What I wish to do is this:

"select customer ,count (*) from subscriber

where customer between 1 and 40000000

and customer not in (161,3)

and sub_status =...