例: case when len(Remark)>100 then left(100)+''...'' else Remark end as Remark 转载于:https://www.cnblogs.com/wangpei/archive/2008/12/04/1347442.html