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 containing 10 space characters.

SELECT SPACE(10); 

Definition and Usage

The SPACE() function generates a string containing a designated quantity of space characters.

Syntax

SPACE(number)

Parameter Values

Parameter

Description

number

Mandatory. The quantity of space characters to be produced.

Technical Details

Works in: From MySQL 4.0