repeat.md

description
Builds a string by repeating the input for the specified number of times

REPEAT

Syntax

REPEAT(expression varchar, nTimes int32) → varchar

• expression: The input string from which the output string is built.
• nTimes: The number of times the input expression should be repeated.

Examples

{% code title="REPEAT example" %}

SELECT REPEAT('abc', 3)
-- abcabcabc

{% endcode %}