REPEAT( ) function

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

Syntax

REPEAT(string, count)

Parameters

Name	Type	Description
string	character	The field, expression, or literal value to repeat.
count	numeric	The number of times to repeat the value of string.

Output

Character.

Examples

Basic examples

Returns "ABCABCABC":

REPEAT("ABC",3)

Returns "000000000":

REPEAT("0",9)

Remarks

When to use REPEAT( )

Use the REPEAT( ) function to initialize a variable with constant values or blanks, or to set a default value for a computed field.