Replicate SQL Server

SQL Server > Built-In Functions > REPLICATE

Repeats a string with specified number of times.

Example:

SELECT REPLICATE ('a',5)

Result:

aaaaa