I have two tables. One contains patterns and other contain raw data.
Table_A contains data
Table_B contains Patterns
Select * from Table_A where namea in
(Select '%'+nameb+'%' from Table_B)
I m trying to concatenate nameb with '%' so that it will be used
as wild card for searching in namea.
How can i find which nameb contains within namea??