select * from ou_orgchange a where isnull(closed,0) = 1; select * from ou_orgchange a where closed = 1;