Replacing a specific substring with another substring in a string in SQL stored procedure

Question

I've the following requirement. I'm passing 'ABC DEF' as a command parameter @MyString to a stored procedure. In the stored procedure level i need to replace the substring DEF with XYZ to get the string 'ABC XYZ'. How can i do that?

Thank you. NLV

Andrew · Accepted Answer · 2010-02-03 15:33:07Z

7

Just use the replace function within T-SQL

declare @myOriginalString varchar(50)
set @myOriginalString = 'ABC DEF'
declare @myfindstring varchar(50)
set @myfindstring = 'DEF'
declare @myReplaceString varchar(50)
set @myReplaceString = 'XYZ'

select replace(@myOriginalString,@myFindString, @myReplaceString)

answered Feb 3, 2010 at 15:33

Andrew

27.4k5 gold badges67 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

NLV Over a year ago

Very quick. Great! Thank you Andrew.

Collectives™ on Stack Overflow

Replacing a specific substring with another substring in a string in SQL stored procedure

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related