>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