Set string to the right of the char variable in SQL

PadStringToTheRightOfChar.sql

DECLARE @COUNTER INT = 0;
DECLARE @PADDEDCOUNTER NCHAR(6)

WHILE @COUNTER < 100000
BEGIN
	SET @COUNTER = @COUNTER + 1
	DECLARE @COUNTERSTRING NVARCHAR(6) = CAST(@COUNTER AS NVARCHAR(6));

	SET @PADDEDCOUNTER = REPLICATE(N' ', 6-LEN(@COUNTERSTRING)) + @COUNTERSTRING

	PRINT '"' + @PADDEDCOUNTER + '"'
END