TSQL LIKE MULTIPLE WORD

--1
SELECT * FROM TABLE WHERE FIELD LIKE '%TEXT1%TEXT2%'
-------------
--2
declare @YourFilterString nvarchar(100) = 'TEXT1 TEXT2'
select part
into #FilterTable
from dbo.[SplitString](@YourFilterString,' ')
select *
  from TABLE
  INNER JOIN #FilterTable on TABLE.FIELD LIKE '%' + #FilterTable.part + '%'
DROP TABLE #FilterTable