space function

Applies to: Databricks SQL Databricks Runtime

Returns a string consisting of n spaces.

Syntax

space(n)

Arguments

• n: An INTEGER expression that evaluates to a numeric.

Returns

A STRING.

If n is less than or equal to 0 an empty string.

Examples

> SELECT concat('1', space(2), '1');
 1  1

Related functions

• repeat function