REPEAT

Purpose

This function returns the concatenation of n copies of a string.

Syntax

Usage Notes

• If one of the arguments is NULL or if n equals to 0, then NULL is returned.
• Parameter n must be a positive integer between 0 and 999999999.
• The result string may not contain more than 2000000 characters.
• If the input parameters is no string, it is automatically converted to a string.
• For more information, refer to function SPACE.

Example

SELECT REPEAT('abc',3);