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.