[thelist] MS SQL datatype question

Brian Cummiskey Brian at hondaswap.com
Wed May 23 16:09:27 CDT 2007

Casey Crookston wrote:
> If I want to store the value of 1.5, what is the best datatype to use?  This is not currency, it's just 1 ½.  I would have thought it would be "decimal" but that seems to round up.
Float seems to work the best from my experience.

If you have rounding issues, try this:

   cast(FIELD as varchar) AS 'myField'|

More information about the thelist mailing list