isaacr25
asked on
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"
Thanks.
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"
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
this will affect only the part you are replacing...