Update with Replace

Posted on 2011-10-11
Last Modified: 2012-05-12
I want to replace double quotes (") with : " inch"  (a space, then the word inch)
in the FullDescription field:

UPDATE [PET].[dbo].[Nop_Product]
SET FullDescription =

but I forget how to do it. Thanks

Question by:MikeMCSD
    LVL 18

    Expert Comment

    by:Andrej Pirman
    Here is a nice script which might do your work:

    (..and read the last comment on how to run the script)
    LVL 32

    Accepted Solution

    UPDATE [PET].[dbo].[Nop_Product]
    SET FullDescription = REPLACE(FullDescription, '"', ' inch')

    Open in new window

    LVL 16

    Author Closing Comment

    thank you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    In this article I will describe the Detach & Attach 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.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    779 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