{"id":1235,"date":"2019-02-19T11:56:18","date_gmt":"2019-02-19T04:56:18","guid":{"rendered":"http:\/\/www.sqlservertutorial.net\/?page_id=1235"},"modified":"2020-07-11T03:46:10","modified_gmt":"2020-07-10T20:46:10","slug":"sql-server-space-function","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/sql-server-string-functions\/sql-server-space-function\/","title":{"rendered":"SQL Server SPACE Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the SQL Server SPACE()<\/code> function to generate a string of repeated spaces.<\/p>\n\n\n\n

Introduction to SQL Server SPACE() function #<\/a><\/h2>\n\n\n\n

The SPACE()<\/code> function returns a string of repeated spaces. The following shows the syntax of the SPACE()<\/code> function:<\/p>\n\n\n

SPACE(count);\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, count<\/code> is a positive integer that specifies the number of spaces. If count<\/code> is negative, the function will return NULL.<\/p>\n\n\n\n
SQL Server SPACE() function example #<\/a><\/h2>\n\n\n\n
Let’s take some examples of using the SPACE()<\/code> function.<\/p>\n\n\n\n
A) Using SPACE() function with literal strings #<\/a><\/h3>\n\n\n\n
This example concatenates three strings 'John'<\/code>, space, and 'Doe'<\/code> into one. Instead of using the space literal ' '<\/code>, we use the SPACE()<\/code> function:<\/p>\n\n\n
SELECT<\/span> \n    'John'<\/span> + SPACE<\/span>(1<\/span>) + 'Doe'<\/span> full_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Here is the output:<\/p>\n\n\n
full_name\n---------\nJohn Doe\n\n(1 row affected)<\/code><\/span><\/pre>\n\n\n
B) Using SPACE() function with table column #<\/a><\/h3>\n\n\n\n
The following example uses the SPACE()<\/code> function to concatenate the first name, space, and last name in the sales.customers<\/code> table into the full name:<\/p>\n\n\n
SELECT<\/span>\n    first_name + SPACE<\/span>(1<\/span>) + last_name full_name\nFROM<\/span>\n    sales.customers\nORDER<\/span> BY<\/span>\n    first_name,\n    last_name;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
The following picture shows the partial output:<\/p>\n\n\n\n
\"SQL<\/figure>\n\n\n\n
In this tutorial, you have learned how to use the SQL Server SPACE()<\/code> function to generate a sequence of spaces.<\/p>\n
\n\t
\n\t\t
Was this tutorial helpful?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t