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.
LONG VARCHAR
LONG NVARCHAR
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.
SQL/2003 Vendor extension.
The following statement returns the value repeatrepeatrepeat.
SELECT REPEAT( 'repeat', 3 ); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |