space function

Applies to: Databricks SQL Databricks Runtime

Returns a string consisting of n spaces.

space(n)

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

A STRING.

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

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

• repeat function