更新时间:2023-11-06 23:23:46
要有条件地检查字符串的长度,请使用 CASE
.
To conditionally check the length of the string, use CASE
.
SELECT CASE WHEN LEN(comments) <= 60
THEN comments
ELSE LEFT(comments, 60) + '...'
END As Comments
FROM myView