SQL Server – How Like operator work with datetime

Today, my one of the friend shared a very interesting fact about like operator. With the help of this post I am sharing with you all.

We need to convert it to character data while comparing with the like operator.

Let‘s check with example

SQL Server – Like operator does not work with datetime

Like operator with datetime

SQL Server – Like operator does not work with datetime

Like Operator with datetime using convert function

SQL Server – Like operator does not work with datetime

If anybody have any suggestion please share as comment.