Re: % Format Mask
From: Greg Kainz <gregkainz_at_home.com>
Date: 2000/06/23
Message-ID: <3sB45.946$jq3.79883_at_news1.rdc2.tx.home.com>#1/1
Date: 2000/06/23
Message-ID: <3sB45.946$jq3.79883_at_news1.rdc2.tx.home.com>#1/1
I don't have any docs here with me, so I can't tell you if there's a format
mask or not.
But, never having let lack of knowledge stop me, you could
SQL> select mynum*100||'%' from mytab; and just pretend that it's really formatted... Greg
Sandy Sutherland <sandy_at_xilinx.com> wrote in message
news:394F738F.24F4F61F_at_xilinx.com...
> Greetings all,
>
> Can anyone enlighten me on the syntax to create a format mask for a
> percentage
>
> ie turn 0.5 into 50%
>
> Cheers
>
> Sandy
>
Received on Fri Jun 23 2000 - 00:00:00 CEST