title: How to change this mysql select into sql server select statement?
body: <p>I use this mysql statement for concating description which has a length greater than 30..</p>
  
  <pre><code>select if (CHAR_LENGTH(description)&gt;30,CONCAT(SUBSTRING(description,1,30),
  '.....'),description) as description from table
  </code></pre>
  
  <p>How to change this mysql select into sql server select statement?</p>