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