> jerrittwq=# update monitor set units = 'mg/L' where units = NULL
= NULL will never return true.
You want 'where units is null'
d.