No direct function like c#,vb.net provides using string-builder...
In SQL,
using some string function and concatanation you can append values
depends on requirement
feed new string in left/right hand side or in between
e.g.
declare @mytext varchar(10)
declare @Feed varchar(10)
set @mytext = 'Apple Cat '
set @Feed = 'Bat '
select @feed + @mytext
select @myText + @feed
select substring(@mytext,1,6) + @Feed + right(@mytext,4)
select left(@mytext,6) + @Feed + right(@mytext,4)
also visit... for more string functions
http://msdn.microsoft.com/en-us/library/ms181984.aspx[
^]
Happy Coding!
:)