Hi,
I want to count the no. of specific field in the table. i use the sql statement like below :

Select count(invoiceno) as Rcount;
from invoice;

but i don't want then count record result include the records that had been marked deleted in the table. How to do it ?

thanks.

regards,
kengwen