>Ok, I know that isn't possible(or is it?) but my LOCATE statements are VERY sloooow, and I'd love to just be able to seek for more than one expression, like city AND state, coming to the the closest matching record....is this possible? Any thoughts?
One simple way is to build a compound index on city+state.
if seek(city+state)
do something
else
do something else
endif
HTH
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com