help with sql query please
Posted on 2007-11-24
I hope this can be done with a single query, in my db which is access, there is a problem, some of the records in some columns contain a single "</td>" as value, is it possible to have a query go through all records and all columns and simply change "</td>" to ""
the entire content of the field has to match exactly, not a partial match, as some of the fields do contain the string inside as part of their value...
please let me know how to do this exactly, I can run a query on db without problem, but have no idea how this query might look...