>Okay I need to extract records in a table based on it occuring in the table more than 4 times, each time having a different event code.
>
>For example John Smith occurs 5 times with a different event code each time.
>Name Code
>John Smith emd1
>John Smith emd2
>John Smith emd3
>John Smith emd4
>John Smith emd5

Something like this:

select Name, count(*) as _Count from MyTable;
  group by Name;
  where _Count > 4;
  into cursor Temp1
select * from MyTable;
  where Name in (select Name from Temp1);
  into cursor Temp2