title: Using the Like '%" operator in the Sql Command Crystal Reports
body: <p>I have a query to pull out data based on parameters, but now I have a problem using the Like '%' operator in the query, so that when I select data based on this parameter only data with the letters prefixed to this operator can be pulled.</p>
  
  <p>Below is the query</p>
  
  <pre><code>select InventoryName,StockNumber,OBAL,RPO,XEFR,RDJ,RET,TSFR,ISS,PISS,ADJ,CBAL 
  from Transactions
  where InventoryName LIKE 'se%' and ReportingPeriod ='January 2005'
  order by InventoryName,StockNumber
  </code></pre>
  
  <p>For example, with this I am able to pull data which has SE of January 2005. It works fine in SQL 2005 but now I want to use it in Crystal report as a parameter to help pull out data based on the InventoryName chosen and the month and year. I am new to Crystal Reports.</p>