Shlomo,

>I need to write code that checks if records with specific data exist in a table .

Look at the SQL-Select command:

select * ;
   from TheTable ;
   into cusor TheFoundData ;
   where SomeField = 2

if ( _tally > 0 )
   * matching data is in there
else
   * no matching data is in there
endif