DB2 SQL Convert Decimal to Character with Padded Zeros

Question

How can I convert my `DECIMAL(11)` field from `12345678` to a character value of `00012345678`?

Accepted Answer

My LeftPad function without LeftPad function

```
 REPEAT('0', 4-length(MY_COLUMN_VALUE))||CHAR(MY_COLUMN_VALUE) as NEW_COLUMN

MY_COLUMN_VALUE NEW_COLUMN
1               0004
23              0023
```

testing ...

```
SELECT '32' MY_VALUE, REPEAT('0', 4-length('23'))||CHAR('23') as LEFTPAB_MY_VALUE FROM sysibm.sysdummy1
```

Solution