Sybase ADAPTIVE SERVER IQ 12.4.0 - Manual (Page 33)

Adaptive Server IQ 12.4.0 String function REPEAT is supported
Release Bulletin for Digital UNIX 33
{ SELECT * FROM CUSTOMERS }
Note This syntax is not currently supported on Digital UNIX.
9.4.8 String function REPEAT is supported
The string function REPEAT is supported in Adaptive Server IQ version 12.x.
It is documented as follows:
REPEAT function
[String] Function
Returns a string composed of integer-expression instances of string-
expression, concatenated together.
Syntax
REPEAT ( string-expression, numeric-expression )
Parameters
string-expression The string-expression to be repeated.
integer-expression The number of times the string-expression will be repeated.
Examples
The statement
SELECT REPEAT( ’repeat’, 3 )
returns the value repeatrepeatrepeat .
Standards and compatibility
SQL/92 Vendor extension.
Sybase REPEAT is not supported in Adaptive Server Enterprise, but
REPLICATE provides the same capabilities.
9.4.9 Correction to CHAR function
The Adaptive Server IQ Reference Manual incorrectly lists the CHAR function
as accepting a string-expr argument. The correct syntax is
CHAR ( integer-expr )
9.4.10 Number(*) function not supported