Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 371
  • Last Modified:

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?
0
bemara57
Asked:
bemara57
1 Solution
 
udaya kumar laligondlaTechnical LeadCommented:
you can use replace as
update tablename
set Fieldname = REPLACE(Fieldname,'cde','xxx')

0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now