Wednesday, February 8, 2012

REPLICATE

Repeats a string value a specified number of times.


SELECT EmpName,
REPLICATE('0',4)+
convert(varchar(20),
Empid
)
+REPLICATE('0',2)
AS ID FROM Employee



No comments:

Post a Comment