REPLICATE (SQL Server Compact Edition)
SQL Server 2005
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 (LastName, 2) AS "LastName Twice" FROM Employees
This is the result set:
LastName Twice -------------- FunkFunk PearsonPearson CalafatoCalafato DannerDanner LeeLee ByhamByham SuttonSutton KingKing DoyleDoyle
