> As you've been told already, try to avoid server-side formatting.

Yes :).

> But in this case you could try to cast the amount:
> create table my_view (
> ....
> amount
> ) as select ...,
> case (IS_PERCENT) when 1 then (AMOUNT || '%')
> else ('$' || cast(AMOUNT as numeric(18,2))) end
> from my_table
> ...

This works somewhat, but still no thousand separators.

Thank you,
regards,
sugi.