REPLICATE (SQL Server Compact Edition)
Repeats a character expression a specified number of times.
Syntax
REPLICATE ( character_expression, integer_expression)
Arguments
- 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.
Return Value
nvarchar or ntext
Code Example
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