Solved

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

Posted on 2011-02-16
2
233 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to PARSE a text field that is delimited by '~' character? 3 63
sql query help 2 53
How can i get data when i use where clause with group by? 3 37
Sql query 107 64
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…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

822 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