ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

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.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

REPEAT function [String]

Example 

The following statement returns the value repeatrepeatrepeat.

SELECT REPLICATE( 'repeat', 3 )