Hi,

I'm not used to working with the money values.

Can you tell me the best way to store salaries(£) in a DB?

I'm using the int datatype at the moment, but I'm having trouble entering values into my db, 8,000 enters as 80,000.

TIA

Use money or float

http://sqlservercode.blogspot.com/

 I like to use DEC(9,3)for money types. That's somewhat arbitrary, but I started using it when I had to develop some stuff that took a datafeed from a major securities rating company, so I figured it was credible based on that.

Regards,
Meredith Shaebanyan

I think Money, numeric or Dec work but I disagree with another above. I would NOT use float. Float is an aporximate value. You can get into situations where you stored 12.34, but what you get returned is 12.33. Although that data type does save space and have a lot of flexibility it can cause slight variations in what you saved vs what was returned and displayed to you users. It is also a common problem in accurate detailed calculations.