sql查询不包含字符的表

select * from   (select * from tl_qlsoft_cql_qlcheck_qlstye_bw_bj where chgJrewightnum !='/' and chgjscore !='/') t  where chbwid=22

-------------

select chgJrewightnum,chgjscore * CAST(chgJrewightnum  AS FLOAT)  + CAST(chgjscore  AS FLOAT) as count3 from (select * from tl_qlsoft_cql_qlcheck_qlstye_bw_bj where chgJrewightnum !='/' and chgjscore !='/') t  where chbwid=22 

-------------------

select count( distinct(gjzxbhNO)) from tl_qlsoft_cql_qlcheck_qlstye_bw_gj_checkDispd where

================

select isnull( sum( CAST( isnull(chgjrescore,0)  AS FLOAT))  ,0 ) from (select * from tl_qlsoft_cql_qlcheck_qlstye_bw_bj where chgjrescore !='/' ) t where chbwid=29