subject:"LPAD\(\), RPAD\(\) problem"

Re: LPAD(), RPAD() problem

2002-08-02 Thread Gelu Gogancea

PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Alexander Dsugan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 02, 2002 11:06 AM Subject: LPAD(), RPAD() problem > Hello. > > I have a trouble. > > "select LPAD(1, 8, 0);"

LPAD(), RPAD() problem

2002-08-02 Thread Alexander Dsugan

Hello. I have a trouble. "select LPAD(1, 8, 0);" or "select LPAD(int_field, 8, 0) from TABLE;" produces "" 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;" ->