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

Question

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?

Answer 1

SELECT LEFT(description,30) as description FROM table

Answer 2

Use a CASE statement; something like:

SELECT 
    CASE WHEN CHAR_LENGTH(description) > 30 
    THEN SUBSTRING(description,1,30) + '.....'
    ELSE description
    END as description 
FROM 
    table

Answer 3

select 

    description = 

       case when LEN(description) > 30 then
           SUBSTRING(description,1,30) + '.....'
       else
           description 
       end

from table

Answer 4

SELECT
    CAST(Description AS VARCHAR(30))
    +
    CASE WHEN DATALENGTH(Description) > 30 THEN '...' ELSE '' END AS Description
FROM table

This is NULL-proof and works for text datatypes.