title: Where clause based on value from function
body: <p>I have a SQL Server function that combines some data for output for an address</p>
  
  <pre><code>dbo.pt_FormatAddress(
      Permit_Address.Permit_No,
      Permit_Address.Permit_Fraction,
      Permit_Address.Permit_Direction,
      Permit_Address.Permit_Address,
      Permit_Address.Permit_Unit,
      Permit_Address.Permit_CityName,
      0,
      0,
      0
  ) as ADR
  </code></pre>
  
  <p>This will produce a result like:</p>
  
  <pre><code>400 BELL STREET, SOMECITY
  </code></pre>
  
  <p>I would like to do something like this in the <code>WHERE</code> Clause:</p>
  
  <pre><code>WHERE ADR LIKE '%400 BELL STREET%'
  </code></pre>
  
  <p>Is this possible?</p>