repeat function

Applies to: Databricks SQL Databricks Runtime

Returns the string that repeats expr n times.

repeat(expr, n)

• expr: A STRING expression.
• n: An INTEGER expression.

A STRING.

If n is less than 1, an empty string.

> SELECT repeat('123', 2);
 123123

• space function