How to change this mysql select into sql server select statement?

Posted by Pandiya Chendur on Stack Overflow See other posts from Stack Overflow or by Pandiya Chendur
Published on 2010-05-12T05:59:23Z Indexed on 2010/05/12 6:04 UTC
Read the original article Hit count: 221

Filed under:
|
|
|

I use this mysql statement for concating description which has a length greater than 30..

select if (CHAR_LENGTH(description)>30,CONCAT(SUBSTRING(description,1,30),
'.....'),description) as description from table

How to change this mysql select into sql server select statement?

© Stack Overflow or respective owner

Related posts about sql-server-2005

Related posts about mysql