How to insert text in another text in Sql Server 2012

• avdhut.k

  SSCrazy

  Points: 2834

  More actions

  December 11, 2012 at 10:18 pm

  #286115

  Hi,

  I want to Insert Some Text in Another Text in Sql Server 2008.

  How to do this.

  For Eg,

  I Have a text as,

  'Sett_FY_Mast_2012'

  I needed that as Output is,

  'Sett_FY_Pooled_Mast_2012'

  ------------------------------------------------

  Means I want to insert "_Pooled" before the word "Mast"

  Thanks in Advance!

• sanket kokane

  Hall of Fame

  Points: 3465

  More actions

  December 11, 2012 at 10:30 pm

  #1567694

  declare @txt varchar (50)= 'Sett_FY_Mast_2012'

  select stuff(@txt,8,0,'_Pooled')

  -----------------------------------------------------------------------------
  संकेत कोकणे

• avdhut.k

  SSCrazy

  Points: 2834

  More actions

  December 11, 2012 at 10:37 pm

  #1567695

  Thanks Sanket!

• jeetsingh.cs

  SSCommitted

  Points: 1761

  More actions

  December 11, 2012 at 10:43 pm

  #1567696

  Stuff will do the trick

  refer to this link for more information

  http://msdn.microsoft.com/en-us/library/ms188043.aspx

• avdhut.k

  SSCrazy

  Points: 2834

  More actions

  December 11, 2012 at 11:28 pm

  #1567707

  Thanks !!!!!!!!!!!!!!!!!!!!!!!