decimal 类型在语句中怎么写的

[usernamezero]

表 A
单号,欠款
12-2 0.00
12-3 3000.00


select * from A where QianKuanJinE>cast(0 as decimal(18,2))
或着
select * from A where QianKuanJinE>0

怎么都出不来 12-3的这个单号呢? 帮解答谢谢

[keer003]

[usernamezero]

我的字段是decimal类型的,真出不来,

[usernamezero]

可以写的不对

[htl258_Tony]

[Quote=引用楼主 usernamezero 的回复:]
表 A
单号,欠款
12-2 0.00
12-3 3000.00


select * from A where QianKuanJinE>cast(0 as decimal(18,2))
或着
select * from A where QianKuanJinE>0

怎么都出不来 12-3的这个单号呢? 帮解答谢谢
[/Quote]
会出来的。

[华夏小卒]

select * from A where QianKuanJinE>0

这个就可以了啊，你欠款是什么类型哦

[Mr_Nice]

--> 测试数据：[A1]
if object_id('[A1]') is not null drop table [A1]
create table [A1]([单号欠款] varchar(4),[C2] numeric(6,2))
insert [A1]
select '12-2',0.00 union all
select '12-3',3000.00

select * from [A1]


select * from A1 where [C2]>cast(0 as decimal(18,2))

/*
单号欠款 C2
---- ---------------------------------------
12-3 3000.00

(1 行受影响)
*/