Hello.
I have a trouble.
"select LPAD(1, 8, 0);" or
"select LPAD(int_field, 8, 0) from TABLE;" produces "00000000" result.
The function doesn't work as expected :(
As I understand from the manul it should produce the same result as:
"select CONCAT(REPEAT(0, 8 - LENGTH(ID)), ID) from TABLE;" -> "00000001",
etc.
(MySQL version() = 3.23.41-log, OS: Linux-Mandrake 8.0,
3.23.38-nt, OS: W2K SP 3)
With best regards,
Alexander.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
