>I create a cursor that pulls up records that are in a specific stage of a sign-off cycle(work flow). The powers that be now don't just want the Que to be a department basket but be able to make assingments at will. This will also give them the option to not assign it at all. What I need my cursor to do is complile the assigned to a particular person plus any not assigned that belong to their department. I would only exclude those assigned to someone else. Note the unassigned have blank fields for assignment.
Don't include the assignment field in the WHERE and it will pull everything for the dept.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer