How to add space in string using Space function

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

Syntax

SPACE(number)