replicate

Returns a string with the same datatype as char_expr or uchar_expr containing the same expression repeated the specified number of times or as many times as fits into 16K, whichever is less.

Syntax

replicate(char_expr | uchar_expr, integer_expr)

Parameters

char_expr – is a character-type column name, variable, or constant expression of char, varchar, nchar, or nvarchar type.
uchar_expr – is a character-type column name, variable, or constant expression of unichar or univarchar type.
integer_expr – is any integer (tinyint, smallint, or int) column name, variable, or constant expression.

Examples

Example 1 – Returns a string consisting of "abcd" three times:
```
select replicate("abcd", 3)
```
```
------------ 
abcdabcdabcd
```

Usage

If char_expr or uchar_expr is NULL, returns a single NULL.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute replicate.