Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Functions » Alphabetical list of functions

REPLACE function [String] Next Page

REPLICATE function [String]

Concatenates a string a specified number of times.


REPLICATE( string-expression, integer-expression )


string-expression    The string to be repeated.

integer-expression    The number of times the string is to be repeated.


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.

Alternatively, try using the REPEAT function.

This function supports NCHAR inputs and/or outputs.

See also
Standards and compatibility

The following statement returns the value repeatrepeatrepeat.

SELECT REPLICATE( 'repeat', 3 );