>When implementing credit and money fields in SQL Server, do people generally store credits as negative numbers or add a Credit logical field and store all money items as positive numbers?
>
>What would be the pros and cons of this in manipulating money data in the SQL Server context?
>
>Thanks,
>Bill
I would say in general that it would be much easier to get a summary value by storing positive and negative amounts. I would not want to store and have to maintain a separate field to designate whether debit or credit.
HTH
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown