Replicate Function in SQL Server

SELECT REPLICATE( ' Randheer ' , 2 ) function in SQL Server repeats the string no of times as specified in function.

This is T-SQL Function and it repeats the string/character expression N number of times specified in the function.