REPEAT

Purpose

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

Syntax

repeat::=

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);