怎么在表字段中运算结果???

[long_0662]

Create Table T
(a int;
b nchar(1);
c int
)
insert into t(a,b,c) Values(100,'-',20)
insert into t(a,b,c) Values(110,'+',20)
insert into t(a,b,c) Values(900,'*',400)
insert into t(a,b,c) Values(900,'/',300)

select abc from t
如何将b列转为运算符,计算得如下结果
abc 100-20=80
abc 110+20=130
abc 900*400=3600
abc 900/300=3

[我是小数位]

select case when a.b='+' then a.a+a.c when a.b='-' then a.a-a.c when a.b='*' then a.a*a.c when a.b='/' then a.a/a.c end
from t a

[让你望见影子的墙]

select CAST(a as varchar(5))+B+CAST(c as varchar(5)),
	case when a.b='+' then a.a+a.c when a.b='-' then a.a-a.c when a.b='*' then a.a*a.c when a.b='/' then a.a/a.c end
from t a

100-20	80
110+20	130
900*400	360000
900/300	3

[wangrcaction]

select CONVERT(varchar(10),a)+b+CONVERT(varchar(10),c)+'='+ CONVERT(varchar(10),case b when '+' then a+c when '+' then a+c when '-' then a-c when '*' then a*c when '/' then a/c end) from t

[LongRui888]

上面的都是好方法

[renliquan]

SELECT 'abc', CONVERT (varchar(10),a) + CONVERT (varchar(10),b) +CONVERT (varchar(10),c) +'=' + CONVERT (varchar(10), CASE WHEN b='-' THEN a-c WHEN b='+' THEN a+c WHEN b='*' THEN a*c WHEN b='/' THEN a/c END ) FROM t

[twinsoyc]

2楼正解，可以采纳了。