query to search related data in database

Question

 i will use like this:

declare

@SearchString varchar(200) 

 

select @ from tbl_Products 

WHERE ProductName Like '%'+@SearchString+'%' or ProductCode Like '%'+@SearchString+'%'

 

i will get result like :

 

products name: Blue New Product

 

 

and search time : input text like: new blue then it not find any result  i want when input this keyword then i got this product name

 

so please solve it..

thanks..