REPEAT

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

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

REPEAT example

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