Simple?

[Naoise]

Environment : MSSQL, ASP

I have a value ie 1250 in a field in MSSQL of type decimal. If I retrieve this field and display it it will display like 1250 where I would like 1,250 to be displayed. Is there a function either at the data access or business layer where something like this would work :

SELECT DisplayWithComma(Amount) FROM tblMoney

or

strAmount = DisplayWithComma(MyRecordSetObject("Amount"))
response.write strAmount

Thanks,
Naoise

 

[Sheco]

You need the FormatNumber() VBScript function.

 

[Hasfurt]

strAmount = DisplayWithComma(MyRecordSetObject("Amount"))
response.write FormatNumber(strAmount)

 

[Naoise]

Thanks for replies.