Export (0) Print
Expand All
Expand Minimize

REPLICATE (SQL Server Compact)

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 ([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)
Show:
© 2014 Microsoft