Repeats the provided string a requested number of times.

​
Syntax

REPEAT(<expression>, <value>)

​
Parameters

ParameterDescriptionSupported input types
<expression>The string to be repeatedTEXT
<value>The number of needed repetitionsAny INTEGER greater than 0

​
Return Type

TEXT

​
Example

The following example returns the author of a game 5 times repeated. 
SELECT
	REPEAT('UFG Inc.' , 5);
Returns: UFG Inc. UFG Inc. UFG Inc. UFG Inc. UFG Inc.