cover both bases due to this ambiguity =)

deleted IS NULL OR LOWER(deleted) = 'null'