title: Substring and Length function in U SQL
body: <p>I want all records where ParaName matches with tagName. i have tried Length, LEFT and SUBSTRING function, but i think Length,LEFT and SUBSTRING functions are not possible in U-SQL. If possible, what is the syntax??</p>
  
  <pre><code>@var= 
  SELECT * FROM Table
  WHERE ParaName LIKE tagName+"%";
  </code></pre>