How to search/replace a character in SQL Server?

I have some characters I want to replace in my SQL Server tables. Is there native SQL syntax I can use to search and replace a character in some columns of my table?
bemara57Asked:
Who is Participating?
 
udaya kumar laligondlaConnect With a Mentor Technical LeadCommented:
you can use replace as
update tablename
set Fieldname = REPLACE(Fieldname,'cde','xxx')

0
All Courses

From novice to tech pro — start learning today.