FROM statement using source data that's known to have flaws. Back to the OP - either filter out the bad records in the WHERE clause, or put a CASE statement in the UPDATE list. No need for a cursor.

Anyone know how to work with commas and apostrophes coming in as input from a form, and inserting this data into a record using SQL in ASP? If the user enters data with an apostrophe into a text ...