Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Formating a number, with X places to the right.

Author  Topic  cyx Starting Member 9 Posts Posted - 2000-12-14 : 04:44:18 Hello there data-base munchers! :) I'm looking for a function (or whatever) that will act like the FormatNumber(Expression, NumDigitsAfterDecimal) in VBScript. I have this code: CREATE TABLE #TempTable ( ... final_list_price AS ( (list_price_original * coin_rate) * (1 + tax_rate / 100) ) ... ) I want to format all this calculation to a number with 2 digits to the right. HELP ME PLEASE ! ---------------------- Rafi B., Israel.