摘要： select CODE,SNAME ,AMOUNT_TOTAL,AMOUNT_USE,PRICE from holding_s where CAST(substr(AMOUNT_TOTAL,1,3) as int) >0 CAST STR AS INT 阅读全文