Display Currency Fields in ASP

Display Currency Fields in ASP

I am querying an Oracle field that comes back in the format of 25.5. Because this is a currency field, I’d like to manipulate it so that it shows $25.50 before I publish it out to the Web. How can I do this?


Use the FormatCurrency function in VBScript.

strVar = "25.5"' -- the next line outputs $25.20, the 2 refers to' -- the number of decimal placesresponse.write FormatCurrency(strVar, 2)

FormatCurrency returns an expression formatted as a currency value using the currency symbol defined in the system control panel.


Share the Post: