Search by one column to add text at the end of another
I've found this link: http://stackoverflow.com/questions/1...-a-text-column
Which shows me how to add text to the end of a field when searching in that field. However, what I am wanting to do is search 1 field (which is a URL containing field) for a specific string of text, and if it exists, insert some text at the end of another field in the same row.
Field Names: dsptxt and lnktxt
If it finds www.exampleurl.com in lnktxt
then insert HI There at the end of the existing data in dsptxt.
Not sure if possible, but I imagine it is...just not able to figure out how to edit the queries listed in the example link I provided. Any help would be appreciated.