-- Ensure you've run Listing 4.028.sql to create the Employees table

USE Item28Example;
GO

-- Listing 4.33 Non-sargable query to find a particular name in a field which can be Null

SELECT EmployeeID, EmpFirstName, EmpLastName
  FROM Employees
 WHERE IsNull(EmpLastName, 'Viescas') = 'Viescas';

