>I have asked this before but still need help. I have a table with records assigned to several different people and some of the records are not assigned. I want to show in a grid based on the log in a set of records that belong to the individual loged on plus all unassigned records. Note I only want to exclude records assigned to another user. Evereyone would see the unassigned. I know it will take two select statements but how can I set them up?

lcAssignedto = "Steven Dyke "
SELECT *, ;
     IIF( EMPTY(Assignedto), "2", "1") AS Sortorder ;
   FROM mytable ;
   WHERE Assignedto = lcAssignedto OR Assignedto = SPACE( LEN(Assignedto) ) ;
   ORDER BY Sortorder ;
   INTO CURSOR mycursor