This documentation is archived and is not being maintained.

REPLICATE (SQL Server Compact Edition)

Repeats a character expression a specified number of times.


REPLICATE ( character_expression, integer_expression) 

character_expression

An alphanumeric expression of character data, or other data types that are implicitly convertible to nvarchar or ntext.

integer_expression

An expression that can be implicitly converted to int. If integer_expression is negative, a null string is returned.

nvarchar or ntext

The following example replicates twice the last name of each employee in the Employee table.

SELECT REPLICATE (LastName, 2) AS "LastName Twice"
FROM Employees

This is the result set:

LastName Twice
--------------
FunkFunk
PearsonPearson
CalafatoCalafato
DannerDanner
LeeLee
ByhamByham
SuttonSutton
KingKing
DoyleDoyle
Show: