Technische blog Huidige artikelen | Archieven | Zoek SQL Function for padding Olivier Jooris To simulate the .NET function PadLeft(18, "0") You can write in SQL: DECLARE @Amount int = 78912546 SELECT STUFF(@Amount, 1, 0, REPLICATE('0', 18 - LEN(@Amount))) -- 000000000078912546 Categorie: SQL Actions: E-mail | Permalink | waardering 12345