Concatenates a string a specified number of times.

Syntax

REPLICATE( string-expression, integer-expression )

Parameters

Returns

LONG VARCHAR

LONG NVARCHAR

Remarks

If the actual length of the result string exceeds the maximum for the return type, an error occurs. The result is truncated to the maximum string size allowed.

Alternatively, try using the REPEAT function.

This function supports NCHAR inputs and/or outputs.

See also

• REPEAT function [String]
• String functions

Standards and compatibility

Example

The following statement returns the value repeatrepeatrepeat.

SELECT REPLICATE( 'repeat', 3 );