sql - Compare Columns Where One is Similar to Part of Another

Question

I'm trying to write a Select statement where I can see if one column is like part of another.

tblNames 
ID    FullName                   FirstName
1     Mr. John Doe, CEO          John
2     Mr. Jake Doe, Exec        Jake
3     Mrs. Betty Smith, Chair     Jill

The query should return:

3 | Mrs.Betty Smith, Chair | Jill

However mine just returns every row in the table:

SELECT ID, FullName, FirstName
FROM tblNames
WHERE '%' + FirstName + '%' not like Fullname

Any ideas?

Answer 1

Reverse the where, to something like this:

Fullname not like '%' + FirstName + '%'