Formatting currency from SQL 7 using ASP

[tgif]

I am displaying data on a ASP page which has been drawn from a SQL database. The column is formatted as "money" in the database. When the values are displayed in the ASP page they display as "259" with no decimal points, decimals or currency sign as set up in local regional settings. I need the number to display as "$259.00".

Any help please...

 

[Guest_imported]

You need to use formatcurrency() function:
Syntax:
FormatCurrency(Expression[,NumDigitsAfterDecimal [,IncludeLeadingDigit [,UseParensForNegativeNumbers [,GroupDigits]]]])

In your case it would be: formatcurrency("259",2)

 

[tgif]

Thanks, I was using that function but it kept returning a datatype mismatch. I eventually found that when I imported the data from access the monetary values were imported as text.

The level of patience has exceeded all expectations...