SELECT * , 学期名称=case xq when '0' then xn+'/'+str(cast(xn as int)+1)+'学年第一学期' else xn+'/'+str(cast(xn as int)+1)+'学年第二学期' end from tb
ltrim --------------SELECT * ,学期名称=case xq when 0 then xn+'/'+ltrim(str(cast(xn as int)+1))+'学年第一学期' else xn+'/'+ltrim(str(cast(xn as int)+1))+'学年第二学期' end from tb
SELECT *, CASE xq WHEN '0' THEN xn + '/' + Ltrim(str(cast(xn AS int) + 1)) + '学年第一学期' ELSE xn + '/' + Ltrim(str(cast(xn AS int) + 1)) + '学年第二学期' END AS 学期名称 FROM xkjg 呵呵,Str()使用后前面会多空格的,谢谢可可了..结帐..
学期名称=case xq when '0' then xn+'/'+str(cast(xn as int)+1)+'学年第一学期'
else xn+'/'+str(cast(xn as int)+1)+'学年第二学期' end
from tb
--------------SELECT * ,学期名称=case xq when 0 then xn+'/'+ltrim(str(cast(xn as int)+1))+'学年第一学期'
else xn+'/'+ltrim(str(cast(xn as int)+1))+'学年第二学期' end from tb
+ '学年第一学期' ELSE xn + '/' + Ltrim(str(cast(xn AS int) + 1))
+ '学年第二学期' END AS 学期名称
FROM xkjg
呵呵,Str()使用后前面会多空格的,谢谢可可了..结帐..