Space function in SQL Server

Space function is used for the spaces in the string. Space function can be used with the select statement or print statement. For example, to concatenate the first name mid name and last name as a full name then it will return full name without space. See below

   

We can use ‘ ‘ (Space) we will get the space.

  

Here I am using 2 space. If we want 10 spaces, we need to give 10 spaces. It will be a bit tidies task. In this case, we will use Space function.

The syntax of Space function as below

SPACE (number of spaces)

See above highlight row we are getting the full name as Null. All we know if we add any string or number in null the result will be the null. To avoiding the null value we need to handle null value when we are adding these values.

Learn how to handle null values: Different ways to replace the NULL value in SQL server

https://bageshkumarbagi-msbi.blogspot.com/2015/12/different-ways-to-replace-null-in-sql.html

See the result