I need to delete words before a set of words in a field.
eg delete the words before the word price in that field.
I already have a query to replace a certain word but cant see how adapt it to do what I require
update TABLE set
field = replace(
can somebody help please?
Thanks in advance