title: Is there a way to do multiple replace calls inside a query
body: <p>I"ve got a query that looks like:</p>
  
  <pre><code>SELECT LEN(REPLACE(address, ' CA', '')) FROM Tbl
  </code></pre>
  
  <p>I now need to do multiple replaces on a filed before calculating it's length.</p>
  
  <p>ie, I need to do something like:</p>
  
  <pre><code>SELECT LEN(REPLACE(address, ' CA', '') AND REPLACE(address, ' CA', '')) FROM Tbl
  </code></pre>
  
  <p>which is obviously incorrect SQL.</p>
  
  <p>Is there a way to do this?</p>
  
  <p>I'm using MS-SQL 2008 if it matters.</p>