Solved

query  to delete special charcter from a field in sql server 2005

Posted on 2011-02-16
2
247 Views
Last Modified: 2012-05-11
Hi,

I need to remove plus sign from a field in a table in sql server 2005.
For instance, if the field data is  'abc+def+ghijk 12 May 2008.doc'  and  I need following output
'abc def ghijk 12 May 2008.doc'

Any help would be appreciated
0
Comment
Question by:dsk1234
2 Comments
 
LVL 9

Expert Comment

by:s_chilkury
ID: 34913258
SELECT REPLACE(fieldname, '+', ' ') FROM tablename

0
 
LVL 8

Accepted Solution

by:
rushShah earned 250 total points
ID: 34913273
try this,
UPDATE tableName
SET fieldName= REPLACE(fieldName, '+', ' ')

Open in new window

0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

685 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