REPLICATE function [String]

Function

Concatenates a string a specified number of times.

Syntax

REPLICATE ( string-expression, integer-expression )

Parameters

string-expression The string to be repeated.

integer-expression The number of times the string is to be repeated.

Example

The following statement returns the value repeatrepeatrepeat.

SELECT REPLICATE( 'repeat', 3 ) FROM iq_dummy

Usage

REPLICATE is the same as the REPEAT function.

Standards and compatibility

SQL/92 Vendor extension.

Sybase Compatible with Adaptive Server Enterprise.

See also

“REPEAT function [String]”