Couldn't an index be used to speed things up. In VFP if the SQL is stated exactly like the index syntax, doesn't VFP's rushmore technology kick in. I don't have alot of experience with MSSQL but it would seem like an index could be use their as well to speed things up.