craigmj craigmj - 11 days ago 6
SQL Question

Compare Columns Where One is Similar to Part of Another

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?

jzd jzd
Answer

Reverse the where, to something like this:

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