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

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