Returns a string consisting of the specified number of single-byte spaces.
space(integer_expr)
is any integer (tinyint, smallint, or int) column name, variable, or constant expression.
select "aaa", space(4), "bbb"
--- ---- --- aaa bbb
space, a string function, returns a string with the indicated number of single-byte spaces.
For general information about string functions, see “String functions”.
SQL92 – Compliance level: Transact-SQL extension.
Any user can execute space.
