>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

Have a look at set deleted (on) or at the deleted() function