Solved

How to search/replace a character in SQL Server?

Posted on 2009-04-13
1
358 Views
Last Modified: 2012-05-06
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
Comment
Question by:bemara57
1 Comment
 
LVL 12

Accepted Solution

by:
udayakumarlm earned 500 total points
Comment Utility
you can use replace as
update tablename
set Fieldname = REPLACE(Fieldname,'cde','xxx')

0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now