DECLARE @i SMALLINT SET @i=1 While @i <= 20 BEGIN PRINT Right('000' + CAST(@i AS VARCHAR) ,3) SET @i = @i + 1 END