SPACE function [String]

Function

Returns a specified number of spaces.

Syntax

SPACE ( integer-expression )

Parameters

integer-expression The number of spaces to return.

Example

The following statement returns a string containing 10 spaces:

SELECT SPACE( 10 ) FROM iq_dummy

Standards and compatibility

SQL92 Vendor extension

Sybase Compatible with Adaptive Server Enterprise