Subject | RE: [ib-support] For Loop |
---|---|
Author | Leyne, Sean |
Post date | 2001-08-27T19:51:01Z |
Mike,
approach?
Don't quite understand...
Sean
> I tested a query like this and there was no speed degredation.If the query gave you the correct results, what's wrong with using that
>
> SELECT * FROM EXPERIAN WHERE
> (LATITUDE BETWEEN 'xxxxxxxxx' AND 'xxxxxxxxx')
> OR
> (LATITUDE BETWEEN 'xxxxxxxxx' AND 'xxxxxxxxx')
> AND
> (LONGITUDE BETWEEN 'xxxxxxxxx' AND 'xxxxxxxxx'
> OR
> (LONGITUDE BETWEEN 'xxxxxxxxx' AND 'xxxxxxxxx')
approach?
Don't quite understand...
Sean