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.

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.