Repeating any characters or string values using Replicate function.

Suppose,we want to repeat ant character or string 4 times,then we will write as:-

SELECT REPLICATE('vishal ',4) as Repeated_String;

Output:-
vishal vishal vishal vishal

Below query will return repeated number 5 times.

SELECT REPLICATE('5',5) as Repeated_Number;

Output:-
55555