title: SQL Server Boolean Expression evaluation
body: <p>I have a table that stores data from the county appraisal district. I want to add a computed column to tell me if the property is owner-occupied. I define "owner occupied" as true if the property address is the same as the owner address, false otherwise.</p>
  
  <p>Because of data entry inaccuracies in the source data from the county, if I do a strict text comparison I get a lot of false non-owner-occupied results. So I want to test "If the property's street name is not in the owner's address, or if the property's address number is not in the owner's address, then this is a non-owner-occupied property"</p>
  
  <p>I wrote the following:</p>
  
  <pre>
  alter table appriasaldata add 
      IsOwnerOccupied as 
       case
          ((charindex(locastreetnumber, owneraddress) = 0) or (charindex(locastreetname, owneraddress) = 0))
          when TRUE THEN 1 ELSE 0
       end</pre>
  
  <p>SQL Server doesn't like the = signs after the CHARINDEX functions. How can I rewrite this to be acceptable to SQL Server? (I'm using SQL Server 2005 if it matters.)</p>