首页 › Informix › cast(businesssum as varchar(20))

eyejava 发表于 2013-1-30 02:11:15

cast(businesssum as varchar(20))

select
    case when opinionchoice ='02'
                    then '否决'
                        else cast(businesssum2 as varchar)  end,
    T1.businesstype2n
from
    hq_opn T1

查看完整版本: cast(businesssum as varchar(20))