title: How to search for separated values in cloumns from a merged values column
body: <p>I have a database where the data I need to work with is stored into two different columns. I also need to import an excel file and the data in this excel file is all together only separated by a dash. So either I need to figure out how to create a query, maybe an alias, or how to split the column by the dash and then make the query with the data split up.</p>
  
  <p>The code I was trying was the following:</p>
  
  <pre><code>SELECT 
      CAST (dbo_predios.codigo_manzana_predio as nvarchar(55))+'- 
      '+CAST(dbo_predios.codigo_lote_predio as nvarchar(55)) as ROL_AVALUO 
  FROM dbo_predios 
  WHERE ROL_AVALUO like '%9132-2%'
  </code></pre>
  
  <p>That is one way I tried, but I don't know well how to split by a determined symbol. The data on the excel comes in the exact same way that I wrote in the "like" portion of the code.</p>