IBM DB2 LPAD / RPAD

Question

I am using db2 v.9.1 on windows 2003 server, so it cannot use LPAD or RPAD functions. because these features only support z / OS right?

Now I use this path for pad notes when COLUMN1 type is VARCHAR

 RIGHT('0000' ||  COLUMN1 ,4) AS  RPAD
 LEFT('0000' ||  COLUMN1 ,4) AS  LPAD

Is there a better way to replace LPAD or RPAD function?

0

Fuangwith S. 13 nov. '08 at 8:14

1 answer

Michael Sharek · Answer 1 · 2008-11-13T16:24:38+0000

I think you probably want the REPEAT scalar function.