title: Using LIKE in Multi-Value Parameter in Crystal Reports 2011
body: <p>I am developing a report in Crystal Reports 2011 that has 3 sub-reports pulling data from 3 different databases. I have a Multi-Value Parameter (String) in the main report that passes the input values to the 3 sub-reports which have the same Multi-Value String Parameter.</p>
  
  <p>Sample Input Values are:</p>
  
  <pre><code> P000000030,
  
   P000000930,
  
   P000001730
  </code></pre>
  
  <p>The user does not want to input the leading alpha character and preceeding zeroes. They want to input the following:</p>
  
  <p>30,
   930,
   1730</p>
  
  <p>The sub-report pulls all of the records successfully if the user puts the entire string value in with the following Record Selection Criteria, but it does not work with the partial strings input:</p>
  
  <p>{Command.Puchase Order} in {?Pm-?Reference}</p>
  
  <p>Can anyone advise the syntax needed to pull the data in the subreport with the substrings as inputs?</p>
  
  <p>Thanks in advance!</p>