How to insert text in another text in Sql Server 2012

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » How to insert text in another text in Sql...

How to insert text in another text in Sql Server 2012

Rate Topic

Display Mode

Topic Options

Author

Message

avdhut.k

Posted Tuesday, December 11, 2012 10:18 PM

Valued Member

Group: General Forum Members
Last Login: Today @ 5:32 AM
Points: 57, Visits: 138

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!

Post #1395426

sanket kokane

Posted Tuesday, December 11, 2012 10:30 PM

Old Hand

Group: General Forum Members
Last Login: Today @ 5:04 AM
Points: 323, Visits: 966

declare @txt varchar (50)= 'Sett_FY_Mast_2012'

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

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

Post #1395430

avdhut.k

Posted Tuesday, December 11, 2012 10:37 PM

Valued Member

Group: General Forum Members
Last Login: Today @ 5:32 AM
Points: 57, Visits: 138

Thanks Sanket!

Post #1395431

jeetsingh.cs

Posted Tuesday, December 11, 2012 10:43 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:06 PM
Points: 179, Visits: 380

Stuff will do the trick
refer to this link for more information
http://msdn.microsoft.com/en-us/library/ms188043.aspx

Post #1395432

avdhut.k

Posted Tuesday, December 11, 2012 11:28 PM

Valued Member

Group: General Forum Members
Last Login: Today @ 5:32 AM
Points: 57, Visits: 138

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

Post #1395443

« Prev Topic | Next Topic »

Permissions