Categories: String, Binary

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

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