Repeats a string value a specified number of times.

Syntax

---

REPEAT(<StringExpression> FOR <IntegerExpression>)
REPEAT(<StringExpression>, <IntegerExpression>)

<StringExpression> = 

Type of:

CHARACTER|CHAR
CHARACTER VARYING|VARCHAR
GUID
CHARACTER LARGE OBJECT|CLOB

Returns

---

Same as input

Usage

---

The REPEAT function repeats a given string a specified number of times and returns the concatenated result.

Examples

---

SELECT REPEAT( '=' FOR 60) + #13 + #10 +
       CustomerID + #13 + #10 +
       REPEAT( '=' FOR 60) + #13 + #10 +
Notes AS Notes
FROM Customers

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: