MS-SQL statement to replace/delete sub-strings
- by StefanE
Hi,
I have a table with 6 columns containing HTML content with some markups in it and now when moving to a new designed site most of this HTML code has to be deleted. More or less all tags except and .
Is there a nice way of doing this, identify all tags end delete them within the data? I'm sure there are no < symbols in the test so a regular expression would maybe work?
My alternative is to fecth every row, process it and update the database but I'm guessing this is possible to do in SQL directly.
Thanks,
Stefan