Question

sql server语句问题

我想判断从一个表里查出来的字段的撒谎是否大于一个值,如果大于一个值的话,用另外一个代替并重命名,怎么写,下面是ACCESS写的,怎么改成SQL SERVER
SELECT ID,N_hits,IIf(len(N_title)>15,left(N_title,15)+ '...',N_title) AS N_title_c FROM news ORDER BY N_hits DESC

Answer 1

SELECT ID,N_hits,case when len(N_title)>15 then left(N_title,15)+ '...'else N_title end AS N_title_c FROM news ORDER BY N_hits DESC

Answer 2

if或者case