SQL语句过滤字符-数据库

SELECT (case
WHEN LEN(NewsID) > 10 then LEFT(NewsID,8) + '...'
ELSE
NewsID
END
) AS NewsTitle
FROM YourTable
输出直接用<%# DataBinder.Eval(Container.DataItem,"NewsTitle")%>