>>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
Ok. Thanks for the input Wayne.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.