.png)
REPLICATE (SQL Server Compact)
Repeats a character expression a specified number of times.
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)
