At 8/17/2001 09:21 AM (Friday), Mike Grover wrote:

>Should I query in IB like this:
>SELECT * FROM EXPERIAN WHERE LATITUDE BETWEEN "xxxxxxxxx" AND "xxxxxxxxx"
>AND
>LONGITUDE BETWEEN "xxxxxxxxx" AND "xxxxxxxxx"
>or
>SELECT * FROM EXPERIAN WHERE LATITUDE >= "xxxxxxxxx" AND LONGITUDE >=
>"xxxxxxxxx"
>AND LATITUDE <= "xxxxxxxxx" AND LONGITUDE <= "xxxxxxxxx"

I don't think it should matter.

However, you want two separate indexes, one on LATITUDE and one on LONGITUDE.

Those are VARCHAR or CHAR fields, right? (Even though they contain numeric
characters.) If so, you want to use single quotes to delimit them, not
double quotes as you have done above.