Mastering the REPLICATE() Function in SQL Server by SQLYoga Guide
                     WWW.SQLYOGA.COM
Masterin
SQL 
SgERVER  
REPLICATE
Function
How to use REPLICATE 
function?
REPLICATE ("string that you want TO append" ,"INTEGER 
VALUE" )
FIRST parameter, i need TO SET the CHARACTER, which will 
append  it BEFORE the NUMBER.
SECOND parameter, how many times this CHARACTER 
should be  ADD TO the NUMBER.
WWW.SQLYOGA.COM
Example
:
DECLARE @t AS NUMERIC(8,2) 
 SELECT @t = 08.2
SELECT Cast(Replicate(0,6-Len(@t)) 
 AS VARCHAR(5)) +
Cast(@t AS VARCHAR(5))
-> Here I specify that there should be 5 length. In this case 
8.23  has four digit, so this will add one "0" to this number.
WWW.SQLYOGA.COM
WWW.SQLYOGA.COM
Conclusion
The REPLICATE function in SQL Server
It is a simple yet powerful tool for a variety of data manipulation 
tasks.  By mastering its use, you can add significant efficiency and 
flexibility to  your SQL queries. Keep exploring SQLYoga for more tips 
and tricks to  enhance your SQL Server skills.
WWW.SQLYOGA.COM WWW.SQLYOGA.COM
Stay tuned to SQLYoga for more 
 insights and practical guides 
on  SQL Server functionalities.
Happy querying!!