I am wondering if there is a way to do an UPDATE query where only some of the 
text changes.  

The column I need to modify is named “toll_free”
What I need to search for is: 800-
I need it to replace it with is 1-800-
- BUT I don’t want to change instances of 1-800- 
- I need to leave the rest of the toll free phone number in tact.


The Verse of the Day
“Encouragement from God’s Word”

Reply via email to