Fill zero in front of number

SQL Server:

select replicate('0', (10-len('123')))+'123'

Oracle:

SELECT LPad('123',10,'0') FROM dual

DB2:

values char(repeat('0',10-length('123'))||'123',10)