要这样的查询效果

[a2048]

有张表数据如下：

a b
200.23 鼠标
201 光驱

如果没有小数点后面要加二个0
查询后的效果是：
a b
20023 鼠标
20100 光驱

[w75251455]

select left(REPLACE(cast(a as varchar(6)),'.','')+'00000',5),b from #

[li_d_s]

select a * 100 as a ,b from table

[dawugui]

select replace(cast(cast(a as decimal(18,2)) as varchar(10)) , '.' , '') a , b from tb

[bill024]

select case when charindex('.',a)>0 then a else a+'00' end from test

[w75251455]

dawugui(潇洒老乌龟) 20.231
bill024(咖啡熊) 2000

[bill024]

create table test(a varchar(10),b varchar(10))
insert test select '200.23','鼠标'
union all select '201','光驱'

select case when charindex('.',a)>0 then a else a+'00' end from test

drop table test

------------
200.23
20100

[w75251455]

^^

[pandayi]

select left(a*100,5),b
from #

[rcshadow]

我不知道列a的数据类型就写了以下代码：
select case when charindex('.',cast(a as decimal(10,2)>0
then cast(a as decimal(10,2)*100
else cast(a as varchar(12))+'00'
end
,b
from table

[rcshadow]

上面的错了

[lllyyymmm]

select 'a'=case when charindex('.',cast(a as varchar(10))) > 0
then substring(cast(a as varchar(10)),1,charindex('.',cast(a as varchar
(10)))-1)
else cast(a as varchar(10))+'00' end ,
b from table

[lllyyymmm]

错了，没写好，如下：
先把a 转为字符型
select 'a'=(case when charindex('.',a)> 0
then substring(a,1,charindex('.',a)-1)+right(a,len(a) - charindex('.',a))
else a+'00' end) ,
b from table

[w75251455]

这样写没法对~~~

[daring1981]

select replace(28.91,'.','')