MSSQL formatting money field

[efeller]

I have a money field in a MSSQL database. When I enter a price of 10.50, it formats to 10.5

When I run a query to display this on an asp page it displays 10.5 instead of 10.50

How can I get it to display 10.50?

[mehere]

either use FormatNumber or FormatCurrency if you want dollar signs

FormatNumber(field_name,2) or FormatCurrencty(field_name)

[efeller]

Thank you! It worked perfectly! Much appreciated!