declare @tab1 table (id bigint identity(1,1), col1 varchar(100), col2 varchar(100))

insert into @tab1 
select 'I am Whooper Swan Jr.', 'and my father is Whooper Swan Sr.' union all
select 'I am Hooper Swanson', 'and my father is Whooper Swanson Sr.' union all
select 'I am Whooper Seewan Jr.', 'and my father is Whooper Swan Sr.' union all
select 'I am Whoper Swan Jr.', 'and my father is Whooper Swan Sr.'

select * from @tab1 
where col1 like '%Whooper Swan%' and col2 like '%Whooper Swan%'


id                   col1                                               col2                                               
-------------------- -------------------------------------------------- -------------------------------------------------- 
1                    I am Whooper Swan Jr.                              and my father is Whooper Swan Sr.

(1 row(s) affected)