>I need a SQL to find if a key exists in a table. I'm trying to do everything in SQL now. Before I would simply open the table, set the index and do a SEEK(). I there are 1.5 million recs in this table and the key could exists thousands of times or not at all.

In SQL Server:

select cast(case when
 exists (select 1 from SomeTable where SomeField = @Val) then 1 end 0 end as bit) as ValueExists

If you need to do this in VFP, then

select top 1 PKField from myTable where exists (select 1 from myTable where myField = MyValue) order by PKField

Indexseek() on VFP table will probably be faster.