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: |SELECT cast(FIELD as varchar) AS 'myField'|