title: SYBASE ASE String replace in WHERE clause
body: <p>I have a SYBASE ASE table with below values :</p>
  <p>Table 1 :</p>
  <pre><code>**Value**     **Status**
  A          STATUS 1
  B          STATUS 3
  C          STATUS 4 
  </code></pre>
  <p>I have to filter the values based on the list of values like this .. STATUS1,STATUS2,STATUS3 (no space between values).</p>
  <p>I want to remove the space/blanks from the value column from Table 1 and compare against the list.</p>
  <p>I tried the below code and it wasn't working</p>
  <pre><code>select value ,status from  Table 1
  where str_replace(status,' ','') IN ('STATUS1','STATUS2','STATUS3')
  </code></pre>
  <pre><code>select value ,status  from  Table 1
  where str_replace(status,' ',NULL) IN ('STATUS1','STATUS2','STATUS3')
  </code></pre>
  <p>Any idea how to achieve without changing the list values</p>