Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Money/numeric fields

Author  Topic  Joe Starting Member 3 Posts Posted - 2001-03-22 : 11:28:53 Hello, I am an SQL newbie, if there is a forum where I need to post this other than here, please let me know. I am attempting to create a simple database with items and prices. I am using the column type of "money" for the price. The problem is that when I have a product that is "14.50" the zero disappears. When I display this item on my ASP page, the price is, of course "14.5" My question is: what is best way to handle this money datatype. Here is what I've considered: Just make it a char/varchar field All the calculations will be done on the ASP side, so it will work. I'm just wondering how most developers handle this. Thanks, Joe