Concatenates a string a specified number of times.
Syntax
REPEAT ( string-expression, integer-expression )
Parameters
Parameter
|
Description
|
|---|
string-expression
|
The string to be repeated.
|
integer-expression
|
The number of times the string is to
be repeated. If integer-expression is negative,
an empty string is returned.
|
Returns
LONG VARCHAR
LONG NVARCHAR
Note: The
result data type is a LONG
VARCHAR. If you use REPEAT in a SELECT INTO statement,
you must have an Unstructured Data Analytics Option license or use CAST and
set REPEAT to the correct data type and size.
Standards and Compatibility
SQL—Vendor
extension to ISO/ANSI SQL grammar.
Sybase—Not supported in Adaptive Server
Enterprise, but REPLICATE provides the same capabilities.
Example
The following statement returns the value “repeatrepeatrepeat:”
SELECT REPEAT( 'repeat', 3 ) FROM iq_dummy