Multiple Word Search Like — SQL Server

I’m trying to search multiple strings using LIKE but need a workaround instead of using multiple ORs and AND.

I used Contains but getting an error shown here. I tried other listed solution for SQL Server on the web but it ain’t working

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view ‘Production.Table1’ because it is not full-text indexed.

Select Name, col1, col2
From xyz.table
Where Name Like '%Mountain%'
  and Name Like '%Road%'
  and Name Like '%red%'

Leave a Reply

Your email address will not be published.