<div>
declare @val varchar(100), @val1 varchar(100), @val2 varchar(100)<br />
set @val = 'I am feeling lucky today'<br />
set @val1 = REPLACE(@val, 'lucky', 'fortunate')<br />
print @val1 --It would print &quot;I am feeling fortunate today&quot;<br />
<br />
set @val2 = REPLICATE('!', 3) + @val + REPLICATE('!', 3)<br />
print @val2 --It would print &quot;!!!I am feeling lucky today!!!&quot;
</div>


declare @val varchar(100), @val1 varchar(100), @val2 varchar(100)
set @val = 'I am feeling lucky today'
set @val1 = REPLACE(@val, 'lucky', 'fortunate')
print @val1 --It would print "I am feeling fortunate today"

set @val2 = REPLICATE('!', 3) + @val + REPLICATE('!', 3)
print @val2 --It would print "!!!I am feeling lucky today!!!"

<div>
<div class="content wysiwyg-content">
Please experts,<br />
<br />
I undertstand REPLACE, REPLICATE<br />
Please share a real scenario using REPLACE, REPLICATE
</div>
</div>


Please experts,

I undertstand REPLACE, REPLICATE
Please share a real scenario using REPLACE, REPLICATE

sql server 2012: REPLACE, REPLICATE

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.