Decimal point in output field

[fatin]

I have many columns of data. They are all using the money datatype. When I
enter a value into a column such as 32.00, it only shows up as 32. When
outputted to an ASP page using a query it also only displays 32. If the
data is 32.33, then the display is 32.33. How do I get it to display 32.00?
Thanks!

[madankarmukta]

Computed column can be the solution to try over.

Thank you.

[ck9663]

If you input 32.33 from your front-end and made sure that it's the same value in the database but it's only showing 32 in your front-end to display, it's an ASP issue, not SQL Server.

Good Luck!!!


~~ CK