to_char question

From: Phil R Lawrence <prlawrence_at_lehigh.edu>
Date: Fri, 29 Sep 2000 15:24:55 -0400
Message-ID: <8r2q9n$kig@fidoii.CC.Lehigh.EDU>

Why does:

    select 'C' || to_char(1,'0000') TEST from dual;

result in:

    TEST

---

    C 0001

The issue is the un-asked for space in front of the zeroes!

Thanks,
Phil R Lawrence Received on Fri Sep 29 2000 - 14:24:55 CDT