REPEAT function [String]

REPEAT( string-expression, integer-expression )

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.

LONG VARCHAR

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.

The behavior of this function is identical to that of the REPLICATE function.

SQL/2008 Vendor extension.

The following statement returns the value repeatrepeatrepeat.

SELECT REPEAT( 'repeat', 3 );

REPEAT function [String]

Syntax

Parameters

Returns

Remarks

See also

Standards and compatibility

Example