space

Syntax

space(integer_expr)

Parameters

• integer_expr – is any integer (tinyint, smallint, or int) column name, variable, or constant expression.

Examples

• Example 1 – Returns a string with four spaces between "aaa" and "bbb":

  select "aaa", space(4), "bbb"

  --- ---- --- 
  aaa      bbb

Usage

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute space.