Export (0) Print
Expand All
Expand Minimize

REPLICATE (SQL Server Compact Edition)

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 (LastName, 2) AS "LastName Twice"
FROM Employees

This is the result set:

LastName Twice
--------------
FunkFunk
PearsonPearson
CalafatoCalafato
DannerDanner
LeeLee
ByhamByham
SuttonSutton
KingKing
DoyleDoyle
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft