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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions » SQL functions (P-Z)

 

REPEAT function [String]

Concatenates a string a specified number of times.

Syntax
REPEAT( string-expression, integer-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.

Returns

LONG VARCHAR

LONG NVARCHAR

Remarks

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 REPLICATE function.

This function supports NCHAR inputs and/or outputs.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement returns the value repeatrepeatrepeat.

SELECT REPEAT( 'repeat', 3 );