Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Find and Replace

  1. 08-14-2009, 07:48 AM #1
    sprogg is offline Member
    Join Date
    Jan 2009
    Posts
    79

    Default Find and Replace

    Can someone give me the code to find and replace text in the Description field please.

    I have tried update dbo.Product set Description = replace(Description, ‘!’, ‘ ’) but that comes up with an error message.

    Obviously, I'm trying to replace ! with blank space or just remove it completely.

    Thank you!
  2. 08-14-2009, 08:40 AM #2
    sprogg is offline Member
    Join Date
    Jan 2009
    Posts
    79

    Default

    found it



    UPDATE Product
    SET Description = REPLACE(CONVERT(nvarchar(MAX),Description),'OLDTEX T','NEW TEXT')