currency functions - ASP

[cragthehack]

Are there any currency functions in MySQL? I’m using ASP (I’m being forced).. and I’m trying to format a numeric field to display a currency. I figured there might be a way to do this with-in the SQL statement- you know something like: SELECT name, sale_no, currency_function(price) etc…. Any ideas?

Thanks

[hendo]

Why not just pull out the number from your database and then use the FormatCurrency() function in ASP?

I looked in the MySQL manual and there is no currency fuunction as far as I can see.

Hope that helps!

hendo

[Jeremy W.]

There may not be a currency function, but there should be a currency datatype (it's fairly standard).

[cragthehack]

I agree MySQL should have a currency datatype. And thnaks for the headsup with FormatCurrency(). It's a VB Script and I didn't even think of looking there. Dum...