In SQL, the CASE statement functions like IF-THEN-ELSE logic in programming, offering a way to create branches in your query. It's useful for comparing values, evaluating expressions, or applying ...

Learn how to use the SQL CASE statement to perform conditional logic in SQL. This article covers the simple CASE and the searched CASE statements, null values, custom logic, and best practices.

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.