Content Comparison

Select
First_Name
,Last_Name
,Order_Date
,Order_ID

From dbo.Orders

Where Upper(Last_Name) = 'SMITH'
And Order_Date = '2018-12-30'

Select
a.First_Name
,a.Last_Name
,a.Order_Date
,a.Order_ID

From (
Select
	   First_Name
   	,Last_Name
	   ,Upper(Last_Name) As uc_Last_Name
	   ,Order_Date
  	 ,Order_ID

   	From dbo.Orders
 	  Where Order_Date = '2018-12-30'
)a
Where a.uc_Last_Name = 'SMITH'