REPEAT( string-expression, integer-expression )

• LONG VARCHAR
• LONG NVARCHAR

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.

This function supports NCHAR inputs and/or outputs.

• REPLICATE function [String]
• String functions

The following statement returns the value repeatrepeatrepeat.

SELECT REPEAT( 'repeat', 3 );