>>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.
>
>The IndexSeek() would be the most efficient way to do that.
Sergey,
I tried a few SQL commands and SEEK() is a thousand times faster on a large table so we will go with it.
Thanks for the help.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn