Number to Char conversion

Hello all of you!

When I do the following in PL/SQL:

<string> := TO_CHAR(<number>, '00');

The <string> is declared as a CHAR(2) and <number> as a NUMBER(2,0).
<number> always contains 1 - 99.

Why do I always get a errormessage saying the the conversion canīt be done? When I declare the <string> as a CHAR(3) it works... but I get a space/blank
as first position of the string. How come?

I then use
LTRIM(<string>, ' ');
but I wanna know why it works the way it does????

Regards

/\/\attias Received on Sun Feb 07 1999 - 11:05:24 CST