Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

SPACE

Example

Generate a string consisting of 10 spaces.

SELECT SPACE(10);

Definition and Usage

The SPACE() function generates a string composed of a specified number of space characters.

SPACE(number)

Parameter Values

Parameter

Description

number

Required: Specifies the number of space characters to include in the returned string.

Technical Details

Works in:

 SQL Server (from 2008 onward), Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse