REPEAT function [String]

Function

Concatenates a string a specified number of times.

Syntax

REPEAT ( string-expression, integer-expression )

Parameters

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.

Example

The following statement returns the value repeatrepeatrepeat.

SELECT REPEAT( 'repeat', 3 ) FROM iq_dummy

Standards and compatibility

SQL/92 Vendor extension.

Sybase Not supported in Adaptive Server Enterprise, but REPLICATE provides the same capabilities.

See also

“REPLICATE function [String]”