space function in sql server

SQL SPACE()  is a string function  that replicates the number blanks that we want add to the given string.

Syntax

SPACE(number)