SQL 2008 database with three tables
today I found my database was corrupted with a lot of characters from my web site
it added <div style=............ many times on the record
I started deleting the info by hand but I have over 40000 records to go thru.
when I update the record manually I place the cursor on the line right before the <div then I hit CNTRL + Del keys and everything from the right is removed.
e <a href="http://geekiest.net/post/250-awesome-photography-tutorials.aspx
702 is all I want here
This is not positional the values prior to the <div are mixed lengths.
this is all on one column
is there a query that can do this
Hoping to save a lot of time