REPEAT

Search:

 

The function REPEAT returns a character string by repeating count times expression.

SQL Syntax:
 		    REPEAT( expression, count )
Parameters:
 		   expression

Any data type of expressions. If it isn't a binary type then it will convert first to a string data type.

count

The count that the expression is repeating.
Escape Syntax:
 		   {fn REPEAT( expression, count ) }
Return Type:
 		   A character string or binary data type depending of the data type of the expression.

Examples:

  • SELECT REPEAT( 'Peter', 2 )

    Return Values: PeterPeter

see also:
SQL String Functions
SPACE


100% pure Java DBMS
Mirror Site