simpler way to write if today or tomorrow is between ColA or ColB
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.