ASA SQL Reference
SQL Functions
Alphabetical list of functions
Concatenates a string a specified number of times.
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.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not supported in Adaptive Server Enterprise, but REPLICATE provides the same capabilities.
The following statement returns the value repeatrepeatrepeat.
SELECT REPEAT( 'repeat', 3 )