If the data you want is always separated by the and in this way, just add the spaces either side, which will eliminate any strings containing the letters and.

SELECTSQ1.SomeStuff

FROM

(

VALUES('Andrea'),

('Anderson'),

('England'),

('A and B'),

('B and C')

) AS SQ1(SomeStuff)

WHERESQ1.SomeStuff LIKE '% and %'