SQL Server SPACE() Function

The SPACE() function in SQL Server generates a string consisting of a specified number of space characters. While seemingly simple, this function is quite useful for string padding, formatting, or creating strings of a precise length.

SPACE(): Definition and Usage

SPACE() is frequently used to create strings filled with spaces. This is commonly needed for tasks such as formatting data (like aligning text columns), padding data to a certain length, or generating strings of a specific size for other operations. The function's output is a string containing only spaces; the number of spaces is determined by the input parameter.

Syntax

SPACE(number)
      

Parameter Values

Example

Generating a String of Spaces

This example generates a string containing ten spaces.

SELECT SPACE(10);
      

          (Ten spaces will appear here in your query result)