anks for report! It's a known bug:
http://bugs.mysql.com/bug.php?id=2182
>
> Thanks
> Emery
> - Original Message -
> From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, January 12, 2004 12:36
> Sub
CTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 12, 2004 12:36
Subject: Re: Problem with LPAD() function
> "Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
>
> > I think there is a bug in LPAD() function.
> >
> > Just try to run this quer
"Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
> I think there is a bug in LPAD() function.
>
> Just try to run this query:
> SELECT LPAD(12, 3, '0');
> This will correctly return 012 as expected.
>
> But when I run
> SELECT LPAD(512, 3, '0');
> It doesn't retur
