>>SQL against a collection ? Anyone know how?
>
>What do you mean exactly?
>
>I consider a database to persist data between application use and users.
>
>I consider a collection as a way of temporarily storing data for the use of an application.

I do as well. I am just trying to identify alternate methods to remove some lookups I have from a table based solution to another alternative, I am looking for more speed. Currently, I do a lookup like "select * from coord.dat where coord.x >= 3725 And coord.x <= 4405 And coord.y >= 2090 And coord.y <= 2770" This will always return a single record in my data set. I realize that I could use a recordset and keep it available at all times in the app. I was just wondering if I could select an object from a collection in the same way.