>In a table I have following fields:
>
>acno n(5)
>debit n(12.2)
>credit n(12.2)
>balance n(12.2)
>
>I want to count the number of debit entries for a particular acno. And to store the number.
>I failed to do so as I am not finding any idea to proceed. Please help.

m.lnAcNo = 765
select count(*) from table where acno = m.lnacno and debit#0