title: Oracle - Concatenate Field on Where
body: <p>I'm using a Concatenate Field and I'd like to use it on the WHERE of it</p>
  
  <pre><code>TABLE T_EXAMPLE
  RED - FERRARI - F50
  BLUE - PORSHE - S20  
  GREEN - CAMARO - T40
  </code></pre>
  
  <p>I have to show all this fields on a Grid, 'cause of this that I need to put all of them in one field, but I have to filter the Grid with One information that can be any one of the three, example:</p>
  
  <pre><code>SELECT
    T.COLOR || T.CAR,T || T.Model AS FIELD1
  FROM T_EXAMPLE T
  WHERE FIELD1 LIKE '%FER%'
  </code></pre>
  
  <p>Here I want to filter the Ferrari, but I've tried to do like this but I got an error (Invalid Identifier).</p>
  
  <p>Can anyone help me??</p>