Using CASE in MS SQL

Code to update a field using “CASE” (instead of using if-then-else):

MySQL Working with Nulls

Some useful MySQL commands:

How to find rows with null data and delete them:

delete from corridor where wb_id is null;

Note that this WON’T work:

delete from corridor where wb_id = null;

How to update a blank field: