Concatenates a string a specified number of times.
Parameter |
Description |
---|---|
string-expression |
The string to be repeated. |
integer-expression |
The number of times the string is to be repeated. |
LONG VARCHAR
LONG NVARCHAR
The result data type is a LONG VARCHAR. If you use REPLICATE in a SELECT INTO statement, you must have an Unstructured Data Analytics Option license or use CAST and set REPLICATE to the correct data type and size.
The following statement returns the value “repeatrepeatrepeat:”
SELECT REPLICATE( 'repeat', 3 ) FROM iq_dummy