I wanted to add some 0 to a number, so that after a Rollup with “concate unique” the numbers will be in the right order.

This doesn’t look nice and right.

So I did some research and found it could be done with

`LPAD({mynumber},3,0)`

This would add 0 or 00 in case the number is not 3 digits.

Alas there is no LPAD, although there is a RPAD.

Could you add LPAD please?

Bonus, is there an alternative to LPAD which could be used to add leading zeros to a number?