• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

Replace query needed

MSSQL Server 2000

I have a field where the content could be something like:

mannn ackenn irnrr

This is what I need to do.  I need to find, for instance, all instances of "ackenn" and change it to "acken"
I don't need to set the entire value of the field to "acken". I just need to replace all instances of "ackenn" with "acken"

1 Solution
Patrick MatthewsCommented:
UPDATE YourTable
SET YourColumn = REPLACE(YourColumn, 'ackenn', 'acken')
Sham HaqueSenior SAP CRM ConsultantCommented:
SELECT REPLACE (yourField,'ackenn','acken')

this will affect only the part you are replacing...

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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