Repeats a character expression a specified number of times.
REPLICATE (character_expression, integer_expression)
Arguments
character_expression
An alphanumeric expression of character data, or other data types that are implicitly convertible to nvarcharorntext.integer_expression
An expression that can be implicitly converted to int. If integer_expression is negative, a null string is returned.
nvarchar or ntext
Code Example
The following example replicates twice the last name of each employee in the Employee table.
SELECT REPLICATE ([Last Name], 2) AS [Last name twice]
FROM Employees
This is the result set:
Last name twice
--------------------
DavolioDavolio
FullerFuller
LeverlingLeverling
PeacockPeacock
BuchananBuchanan
SuyamaSuyama
KingKing
CallahanCallahan
DodsworthDodsworth
HellsternHellstern
SmithSmith
PattersonPatterson
BridBrid
MartinMartin
PereiraPereira
(15 rows affected)