simpler way to write if today or tomorrow is between ColA or ColB SELECT * FROM my_table WHERE
getdate() between SPRFRDTE and SPRTODTE
or dateadd(DD, 1, getdate()) between SPRFRDTE and SPRTODTE


is there a way to write this as if TODAY or TOMORROW is between SPRFRDTE and SPRTODTE rather than if TODAY is between SPRFRDTE and SPRTODTE or if TOMORROW is between SPRFRDTE and SPRTODTE
The issue is how to check for overlapping ranges:

WHERE SPRFRDTE &lt;= dateadd(day, 1, cast(getdate() as date))
  AND cast(getdate() as date) &lt;= SPRTODTE 
  AND SPRFRDTE &lt;= SPRTODTE ;                 -- this might not be needed.


The very last condition is just a technical detail and may not be needed if you are sure (i.e. there is a constraint) that enforces that CHECK (SPRFRDTE &lt;= SPRTODTE).

If however such abnormal values are allowed, you need to include that condition as well for the query to be equivalent to the version with the two BETWEEN.