Skip to main content

REPEAT

The REPEAT function in SQL is used to repeat a string for a specified number of times.

Syntax​

REPEAT(string, number)

Parameters​

  • string: The string to be repeated.
  • number: The number of times to repeat the string.

Return Value​

The function returns a string which is the concatenation of the input string repeated the specified number of times.

Errors​

  • If the parameters are not in the correct format, a TranslateError::FunctionArgsLengthNotMatching error will be returned. This function requires exactly two arguments.
  • If either string or number are not string values, a EvaluateError::FunctionRequiresStringValue error will be returned.

Examples​

Consider a table Item created and filled with the following data:

CREATE TABLE Item (name TEXT);
INSERT INTO Item VALUES ('hello');

You can use the REPEAT function to repeat the name values:

SELECT REPEAT(name, 2) AS test FROM Item;

This will return:

hellohello

The 'hello' string is repeated twice as specified by the second parameter to the REPEAT function.