I have a table A with a few columns; Name and Description store string data and are of type nvarchar(250) and nvarchar(max).
Is there a way to clean up the faulty data in these columns to remove the script tags if any from them? This is the data as of now:
Note: code is being written in backend to strip tags for new entries being made to the table.