The REPLICATE function concatenates a string with itself a specified number of times.
REPLICATE
Syntax is: REPLICATE ( string-expression , integer )
SELECT REPLICATE ('Hello',4) --returns 'HelloHelloHelloHello'