The SQL SPACE function is one of the String Function, which is used to return the string of repeated spaces. In this article we will show you, How to use SPACE function with an example.
SQL SPACE Function Syntax
The basic syntax behind the SPACE in SQL Server is as shown below:
SQL SPACE Function Example 1
The String SPACE Function simply returns the string of repeated spaces. The following query will show you the multiple ways to use this function.
-- SPACE in SQL example DECLARE @Str1 VARCHAR(50), @Str2 VARCHAR(50) SET @Str1 = 'Learn ' SET @Str2 = 'SQL Server' SELECT @Str1 + SPACE(1) + @Str2 AS Result1 SELECT @Str1 + SPACE(3) + @Str2 AS Result2 SELECT 'Learn' + SPACE(5) +'SQL Server'+ SPACE(8) + '2014' AS Result3
Within this space function example query, the below lines of code is used to declare two VARCHAR variables and assigning them some random data.
DECLARE @Str1 VARCHAR(50), @Str2 VARCHAR(50) SET @Str1 = 'Learn ' SET @Str2 = 'SQL Server'
Next statement will combine the two variable along with SPACE(1) and produce the string result. It means, we are assigning single space between the two string variables. We also assigned new name to that result as ‘Result1’ using SQL ALIAS Column.
SELECT @Str1 + SPACE(1) + @Str2 AS Result1
In the next line, We are adding five spaces in between the Learn, SQL Server, and 8 spaces between SQL Server, 2014
SELECT 'Learn' + SPACE(5) +'SQL Server'+ SPACE(8) + '2014' AS Result3
SQL SPACE Function Example 2
The SPACE function also helpful when you are combining (concatenating) multiple columns. In this example,We are going combine the First name and Last Name columns present in the Employe column to get Full name, and to get the empty space we will use SPACE function.
For this string space demonstration, We are going to use the below shown data
SELECT [FirstName] ,[LastName] ,[FirstName] + SPACE(5) + [LastName] AS [Full Name] ,[DepartmentName] ,[Email] FROM [SQL Tutorial].[dbo].[Employe]
TIP: We used this SPACE(5) to get FIVE empty spaces.
SQL SPACE Function Example 3
In this string space function in sql server example,We are going combine the First name, five spaces, Last Name, one space, string text = ‘is working as’, eight spaces, and Department name columns present in the Employe table.
SELECT [FirstName] ,[LastName] ,[DepartmentName] ,[FirstName] + SPACE(5) + [LastName] + SPACE(1) + 'is Working as' + SPACE(8) + [DepartmentName] AS [Description] ,[Email] FROM [SQL Tutorial].[dbo].[Employe]
Thank You for Visiting Our Blog