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.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn