Skip to main content
Version: current [24.3.x]

REPEAT

Categories: String

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