>>

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.

Glad, at least someone could see what I am saying.