求助大神！！！将1.5万，3.5万等等改成15000和35000在sql中怎么改！！！

[weixin_44862372]

有什么语句可以用嘛！！我都迷茫了。跪求大神讲解

[卖水果的net]

create table t(name varchar(10), m varchar(10))
go
insert into t values('zs','2300'),('lisi','1.8W'),('ww','100')
go
select t.*, 
      case 
      when m like '%W' then cast(replace(m,'W','') as decimal(18,2)) * 10000
      else m 
      end  new_col
from t
go
drop table t
go

(3 行受影响)
name       m          new_col
---------- ---------- ---------------------------------------
zs         2300       2300.00
lisi       1.8W       18000.00
ww         100        100.00

(3 行受影响)

[丰云]

UPDATE   tbl
        SET  评价 =  CAST( CAST( REPLACE(评价, '万', '') AS FLOAT) * 10000 AS VARCHAR)  
  WHERE  CHARINDEX('万',  评价) > 0