SELECT RIGHT('00000'+ CONVERT(VARCHAR,Num),6) AS NUM FROM Numbers

[MarioVanDenEijnde]

Hello ALASQL team,

Can we achieve something like below:

SELECT RIGHT('00000'+ CONVERT(VARCHAR,Num),6) AS NUM FROM Numbers

Kind regards,
Mario

[agershun]

You can try:

SELECT ('00000'+ CONVERT(VARCHAR,Num))->substr(-6) AS NUM FROM Numbers

I think you are right and we need to add RIGHT() and LEFT() string functions...

[mathiasrw]

I created a new issue and im closing this one. Please reopen if this did not solve your question :)