how to select records from two columns where one column consist word from second column?
Do you need it to be case sensitive? If not try using LIKE
Create Table #Test
(
ColA Varchar(100)
,ColB Varchar(100)
)

Insert Into #Test
Values ('TEST', 'THIS IS A TEST')
,('String', 'This Also has word string in it')
,('ABC','DEF')
,('123','456')


Select      *
From        #Test 
Where       ColB Like '%' + ColA + '%'