Formatting a number column to look like currency
Ramky99Mar 26 2008 — edited Mar 26 2008Afternoon all,
Having some fun and games writing something that'll make the currency values our app stores look more like currency for another app to read and utilize.
Values are stored in a number field (12 length if that matters) and do not have any decimal points .. e.g. $2000 is stored as 200000 and $19.95 as 1995
I need to write a select that formats these as 2000.00 and 19.95 respectively.
1995 is easy enough, just divide by 100, but where amounts are exact I still need the trailing .00
I've been reading about using the convert function, but that only seems to apply when I want to take something that's a char already - any ideas?
Thanks!!
Adam