Re: use of "B" in format models

Mario;

  No that's not what I'm trying to do. I'm after seeing what a format model such as:

TO_CHAR(some_number, 'B99999') or
TO_CHAR(some_number, 'B000999')

or something along those lines can accomplish. As far as I can ascertain, there is no change in the result between using the format model with the leading "B" to the model with it!

Thanks for sharing your knowledge. :)

Jack

Mario Bucsics wrote:

> Hi !
>
> Do you mean this :
>
> select replace(to_char('111','000000'),0,'B') from dual;
>
> Regards,
> Mario
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Tue May 16 2000 - 00:00:00 CDT