[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 196
  • Last Modified:

Update with Replace

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 =
WHERE

but I forget how to do it. Thanks

0
MikeMCSD
Asked:
MikeMCSD
1 Solution
 
Andrej PirmanCommented:
Here is a nice script which might do your work:
http://blogs.x2line.com/al/archive/2008/05/03/3417.aspx

(..and read the last comment on how to run the script)
0
 
Ephraim WangoyaCommented:
try
UPDATE [PET].[dbo].[Nop_Product]
SET FullDescription = REPLACE(FullDescription, '"', ' inch')

Open in new window

0
 
MikeMCSDAuthor Commented:
thank you
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now