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 5 spaces.

SELECT Space(5AS SpaceString;

Definition and Usage

The Space() function returns a string containing the specified number of space characters.

Syntax

Space(number)

Parameter Values

Parameter

Description

number

Required. Specifies the number of space characters to be returned.

Technical Details

Works in:

 From Access 2000