SQL Server: REPLICATE Function

The REPLICATE() function is a function that is used to repeat a string a number of times.

Syntax:

REPLICATE(input_string, count);

In this syntax:
input_string is the text/character values to be repeated.
count is the number that indicates repetitions that will be made. 

e.g. REPLICATE text that manually typed:

e.g. REPLICATE text from column value of table.