SQL - BETWEEN vs = or What is the alternative to BETWEEN clause?
Topic starter 13/07/2021 11:52 am
What is the alternative to BETWEEN clause in SQL?
13/07/2021 3:44 pm
They are identical.
BETWEEN is a shorthand for the longer syntax.
Use an alternative longer syntax where BETWEEN doesn't work e.g.
Select EventId,EventName from EventMaster where EventDate >= '10/15/2009' and EventDate < '10/19/2009'
(Note: < rather than <= in second condition.)