Q:

SQL - Select rows by entering two words

I have a table that contains a field named Item_Name, which can be composed by one or more words. 

E.g. Item_Name -> Yellow Towel

I'd like to have a query that selects that value by entering "yel tow". 
So far I've a query that selects that value by entering a single word
SELECT Item_Name FROM Articles WHERE Item_Name LIKE '%yel'

And it works fine. 
Thanks in advance for your suggestions. 

A:

Below should be what are you looking for, 
as your attempt is like '%yel', I have used % at beginning as well
declare @search nvarchar(10) = 'yel tow'

declare @my_table table (test nvarchar(30))
insert into @my_table
values ('yellow towel'),
    ('y t'),
    ('yel tow'),
    ('random text')

select * from @my_table where test like '%' + replace(@search,' ', '%') + '%'

Output:
yellow towel
yel tow

Or straight forward select, as pointed in comments:
SELECT Item_Name FROM Articles WHERE Item_Name LIKE '%yel%tow%'

