craigmj craigmj - 1 month ago 14
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.

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

Reverse the where, to something like this:

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