Link Search Menu Expand Document

REPEAT

This function repeats the provided string a requested number of times.

Syntax

REPEAT(<string>, <repeating_number>)
Parameter Description
<string> The string to be repeated.
<repeating_number> The number of needed repetitions. The minimum valid repeating number is 0, which results in an empty string.

Example

SELECT
	REPEAT('repeat 3 times ' , 3);

Returns: repeat 3 times repeat 3 times repeat 3 times