title: Avoiding LIKE Operator in SQL Queries
body: <p>Is there any other way I can write the query for avoiding using "LIKE" operator, as LIKE usage effects Performance while searching large amount of data.</p>
  
  <p>My Table: </p>
  
  <pre><code>Products
  --------
  Id int
  ProductName NVARCHAR(255)
  </code></pre>
  
  <p>Qry: Seraching for products which contains word "EBS" </p>
  
  <pre><code>select * from Products where name like 'EBS%'
  </code></pre>
  
  <p>A full-text index is placed on the Products table. For few products im not able to retrieve data from PRODUCTS Table thru full-text index.</p>
  
  <pre><code>select *
  from Products 
  WHERE contains(ProductName,@Contains)
  Order by    MT.Name 
  </code></pre>
  
  <p>-- No Results for the above qry
  select * from Products where name like 'EBS%'  ( Poor performance)
  so there is anyother way to implement this.</p>