Question:
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?
Answer:
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.