title: Use like operator in Crystal Report record selection formula
body: <p>Hi I am using Crystal Report 2008 to create a report. I need to convert the following oracle SQL query to Crystal Report record selection formula.</p>
  
  <p>Oracle Query is :</p>
  
  <pre><code>AND 
  (
    UPPER(920_SEARCH_REPORT.HANDICAP_TYPE) LIKE UPPER(:HANDICAP_TYPE)
    OR UPPER(920_SEARCH_REPORT.SKSKODENR) LIKE UPPER(:SKSKODENR)
  )
  </code></pre>
  
  <p>I have convert this to formula like following way :</p>
  
  <pre><code>and 
  (
      isnull({?Hancicap_Type}) = true 
          or ((UpperCase({?Hancicap_Type}) Like ("*"&amp;UpperCase({920_SEARCH_REPORT.HANDICAP_TYPE})&amp;"*"))    
          or (UpperCase({?SKSKODENR}) Like ("*"&amp;UpperCase({920_SEARCH_REPORT.SKSKODENR})&amp;"*")))
  )
  </code></pre>
  
  <p>But data is not showing when crystal report executes. But the sql query returns one record.</p>
  
  <p>Can anyone help me to solve the problem.</p>