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 places
response.write FormatCurrency(strVar, 2)
FormatCurrency returns an expression formatted as a currency value using the currency symbol defined in the system control panel.