sql server filter by partial string

I'm using sql server 2008.

I'm using the Employees table from the Northwind database.

Right now i have this query where I input a comma separated string of last nams as input and it returns those employees.


Query 1

-- input is comma delimited list
DECLARE @EmployeeName varchar(2500)
SET @EmployeeName = 'Davolio,Fuller,King,'
-------------
SELECT [EmployeeID]
      ,[LastName]
      ,[FirstName]
      ,[LastName] + ' ' + [FirstName] AS FullName
FROM [Northwind].[dbo].[Employees]
WHERE( nullif( @EmployeeName, '') is null or (',' + @EmployeeName +',' LIKE '%,' + [LastName] + ',%'))
ORDER BY [LastName]

Select allOpen in new window

When I run this query i get this:



Query 2

How do i fix the Query 2 below, so my input could be part of the last name?

So if I input this I should get the same result as Query 1.

-- input is comma delimited list of partial last names
DECLARE @EmployeeName varchar(2500)
SET @EmployeeName = 'Dav,Ful,Kin,'
-------------
SELECT [EmployeeID]
      ,[LastName]
      ,[FirstName]
      ,[LastName] + ' ' + [FirstName] AS FullName
FROM [Northwind].[dbo].[Employees]
WHERE( nullif( @EmployeeName, '') is null or (',' + @EmployeeName +',' LIKE '%,' + [LastName] + ',%'))
ORDER BY [LastName]

Select allOpen in new window