title: How do I use the "like" operator in Crystal Reports 2008 using a parameter
body: <p>I am trying to create a formula based on a parameter that will allow the user to select a description of a supply item, or if none is selected to pull all values.  Also want to be able to give them a parameter that allows them to type any part of the description using the "like" option.  I can get the first part of the formula to work but not the second part.  It is correctly pulling a typed in item or if none is typed it returns all values.   Anything past the first "or" does not work.  Should I create a separate parameter for the second part or can I use the same one?  </p>
  
  <pre><code>IF HASVALUE ({?DESCR}) THEN{Command.DESCRIPTION} = {?DESCR} else true
  or 
    ( UPPER({Command.DESCRIPTION}) LIKE "*" + UPPERCASE({?DESCR}) + "*") 
    OR 
    ( UPPER({Command.DESCRIPTION}) LIKE "*" + UPPERCASE({?DESCR}) + "*") 
  </code></pre>