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

Examples

Usage

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

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute replicate.

Related reference
stuff