ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

SPACE function [String]

Function 

• Returns a specified number of spaces.

Syntax 

SPACE ( integer-expression )

Parameters 

integer expression    The number of spaces to return.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

Example 

The following statement returns a string containing 10 spaces.

SELECT SPACE( 10 )