Hi All,
I know this question has already been here but still...
select to_char(1,'FM999.99')
1
select to_char(0,'FM999.99')
0.
and now I want to get rid of that trailing point !
if this bug hasn't been fixed yet, then what is the best workaround?
should I say something like this:
select case when n = 0 then '0' else to_char(n,'FM999.99') end
Good luck!
Andrew Surinov