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

This blog shows how to repeat an empty space N number of times using SPACE function in SQL

Example:

SELECT 'This is a sample'+ SPACE(5) + 'String'

The expected result would be "This is a sample String"