how to use BETWEEN Operator for negative values

Question

question

prasad.nyalapatla asked Jul 24, '14

how to use BETWEEN Operator for negative values

We had one table, one of column contains negative and positive values, how can we get required data by using BETWEEN operator? Example we are using below syntax, SELECT * FROM FactTable WHERE Lats between 5 and -5 (edited by moderator to try to get the question readable...)

between

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Jul 29, 2014 at 11:40 AM

This web site runs on voting. Please indicate all helpful answers by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate this by clicking on the check mark next to that answer.

0 ·

Answer 1 · 2014-07-24T19:23:11Z

virtualjosh answered Jul 24, '14

Your range is incorrect. There are no numbers greater than or equal to 5 and less than or equal to -5. Use the below instead. BETWEEN -5 AND 5

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton ♦♦ commented · Jul 24, 2014 at 08:34 PM

To clarify @virtualjosh's answer, the `BETWEEN` operator works like this: SELECT * FROM FactTable WHERE Lats BETWEEN x AND y can be thought of as equivalent to: SELECT * FROM FactTable WHERE Lats >= x AND Lats

1 ·

Answer 2 · 2014-07-24T23:30:55Z

Magnus Ahlkvist answered Jul 24, '14

If your 5 and -5 are not constants, but rather variables, and you don't know beforehand which one is the bigger number of the two variables, you could use something like this: SELECT * FROM FactTable WHERE Lats BETWEEN CASE WHEN @variable1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question