Based on what I know, there really isn’t much difference between Money data types and Numeric data types. For the purposes of formatting I want to switch a field that had Money, as it’s original data type to Numeric.
Does anyone know what the major difference is between these two? …and/or have you run into any problems around this type of switch?
that's exactly it..the field was originally money but the function was set up for 2 decimals - we needed 4. We changed it and all was fine for a while. It passing the 4 decimals to the ASP pages just fine..then it just stopped for some reason! That's why we switch the datatype to numeric with 4 decimals. That pushed the right data to the ASP pages but is buggering up some of our bolt on apps. We really want to go back to money 4 decimal but we're kinda stumpped here.
thanks for your help!
Originally posted by snail
If you are going to use datatype money for keeping cost,price,etc. - it is what this datatype for (4 digits after period). If you need more digits after period - money is not your choise.
do you mean the db server's regional OS settings for Money?
this is great help guys - thanks!
Originally posted by MCrowley
Another point, is that the money datatype is tied to your local settings on the DB server. If you want to try saving Euros, or Yen, then you may start pulling your hair out.