This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.
REPEAT
Repeats the provided string a requested number of times.
Syntax
REPEAT(<expression>, <value>)
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<expression> | The string to be repeated | TEXT |
<value> | The number of needed repetitions | Any 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.