title: Powershell : Error: "Input string was not in a correct format."
body: <p>While assigning the below query to a variable the error </p>
  
  <blockquote>
    <p>Input string was not in a correct format.</p>
  </blockquote>
  
  <p>is displayed. I have used similar instances in other scripts which works fine.</p>
  
  <pre><code> $MyQuery = "   select a.asset_name as 'ASSET_NAME',b.asset_name AS
   'ASSET',
                from positions a 
                join appraisal b
                on b.asset_name LIKE CONCAT("%",a.asset_name,"%") where 
                 a.unrealised!= 0 ;"
  </code></pre>