> WHERE discharge IS NULL + > AND company <> '003' + > AND (nexthp < .vtoday + > OR nexthp BETWEEN .vtoday AND (.vtoday + 7))
Just for ease of maintenance, and maybe a little performance, maybe > AND (nexthp < .vtoday + > OR nexthp BETWEEN .vtoday AND (.vtoday + 7)) could be > AND nexthp < (.vtoday + 8) [between is inclusive of 7, right??] so your where clause could be > WHERE discharge IS NULL + > AND company <> '003' + > AND nexthp < (.vtoday + 8) Ben
