SQL Server Transact Basic to Expert - Repeating a string N number of times

This blog shows how to repeat a string N number of times using REPLICATE in SQL Server

Syntax:

REPLICATE ( characterexpression ,integerValue )

Example:

SELECT REPLICATE ('A', 5)

The expected result would be like AAAAA