Contents Index REMAINDER function [Numeric] REPLACE function [String]

ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

REPEAT function [String]


Function 

Concatenates a string a specified number of times.

Syntax 

REPEAT ( string-expressioninteger-expression )

Parameters 

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.

Standards and compatibility 
See also 

REPLICATE function [String]

Example 

The following statement returns the value repeatrepeatrepeat.

SELECT REPEAT( 'repeat', 3 )

Contents Index REMAINDER function [Numeric] REPLACE function [String]