On this page

    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