I'm trying to write a Select statement where I can see if one column is like part of another.
ID FullName FirstName
1 Mr. John Doe, CEO John
2 Mr. Jake Doe, Exec Jake
3 Mrs. Betty Smith, Chair Jill
3 | Mrs.Betty Smith, Chair | Jill
SELECT ID, FullName, FirstName
WHERE '%' + FirstName + '%' not like Fullname
Reverse the where, to something like this:
Fullname not like '%' + FirstName + '%'