You can use the convert function to change NULL to NOT NULL and NOT NULL to NULL.
View this book as PDF