title: Using Decode as a like statement in oracle
body: <p>I need to write a sql statement like this: </p>
  
  <pre><code> SELECT id_segmento AS Segmento, Decode (id_segmento ,  '1' , 'a', 'b' )
  
   FROM mapchile.segmento
  </code></pre>
  
  <p>but in this case I will obtain an 'a' when id_segmento is equal to '1', I need it to be 'a' even when the string id_Segmento contains the '1', kind of like and like statment.</p>
  
  <p>There is any other command like Decode that works this way?</p>
  
  <p>Thanks.</p>