Posted by SQL on 06/02/06 19:24
Also the money data type is not a good candidate since there are some
rounding issues with it. Numeric/decimal is the way to go
Denis the SQL Menace
http://sqlservercode.blogspot.com/
HandersonVA wrote:
> I choose a price field as a money data type, but I cannot change the
> scale of this.
> the default scale is 4 (it dimmed).
> how can I change to 2? I only need 2 scale such as $23.33 instead of
> $23.3344
Navigation:
[Reply to this message]
|