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
Posts
Wednesday, February 8, 2012
Subscribe to:
Comments (Atom)
Readers
My Blog List
Categories
- Case When Statement (2)
- CMD (1)
- Database Email (1)
- DatePart (1)
- Definitions (37)
- ERROR (1)
- Functions (11)
- INDEXING (2)
- LINQ (1)
- Search (1)
- Smo (3)
- Split Function (2)
- SSRS (2)
- System Stored Procedure (4)
- Transaction (1)
- Wildcard (1)
- XML (3)