REPEAT( ) function

Returns a string that repeats a substring a specified number of times.

Syntax

REPEAT(string, count)

Parameters

string

Character. The character string to repeat.

count

Numeric constant. The number of times to repeat the value of the string parameter.

Output

Character.

Remarks

You can use this function to initialize a variable with constant values or blanks, or to set a default value for a computed field.

The maximum length of the returned string is the length of the string parameter multiplied by the count parameter.

Examples

Example Return value

REPEAT("ABC",3)

“ABCABCABC”

REPEAT("0",9)

“000000000”



(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback