select NewsID,News_type,News_name,case when datalength(News)>100 then substring(News,0,100)+'......' else News end as News from News_TB