>

Select myDate
>from DateTester
>where myDate like '2018-01%'
>order by myDate;

>
>You'll also get zero records from this, unless you've changed SQL Server's implicit cast. Try LIKE 'Jan % 2018%'

No, it works for me in MSSQL 2017 using the like '2018-01%'. Gets the records that are for January.

>I've never had issues with BETWEEN using datetimes and paremeterized queries. FWIW. If ticks ever did become an issue, I'd follow your mechanism re date, incrementing the upper boundary and using < if necessary.

Well, Cetin is correct when the datatypes are not Date and are some kind of Datetime instead. I wouldn't risk it.