sql server - BETWEEN operator vs. >= AND <=: Is there a performance difference?

Question

These two statements are logically equivalent:

SELECT * FROM table WHERE someColumn BETWEEN 1 AND 100

SELECT * FROM table WHERE someColumn >= 1 AND someColumn <= 100

Is there a potential performance benefit to one versus the other?

Answer 1

No benefit, just a syntax sugar.

By using the BETWEEN version, you can avoid function reevaluation in some cases.