WHERE statements
WHERE DeletedDate IS NULL
WHERE DeletedDate IS NOT NULL
UPDATE statements
UPDATE your_table SET your_column = NULL
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.