I am trying to create an index. I think I got it to work like I want it. I have some SQLs and it has several items in the WHERE clause. When I let the SQL open the table, it seems to take forever to get the data. Someone suggested I open the table and index it using the same things I have in the WHERE clause. I will see today if it works. I looked at the table with the new index and it puts all the items it should be getting at the top of the table. Sounds good to me anyway. <bg>
Thanks in advance for your help! :-)
Randall L. Johnson