SQL字符截取问题

[anshengcs]

a表
xg sx#
102 10010002

b表
gg s#
1 10010002

要的结果是
A表sx#和B表的S#对比，截取B表sx#的前3位+0+A表xg

结果
b表
gg s#
10010102 10010002

[anshengcs]

问题已解决，谢谢大家

[xptking]

select left(b.sx#,3)+'0'+a.xg as gg,a.sx# as s#
from a,b
where a.sx#=b.s#

[开着拖拉机泡妞]

update b表
set gg =left(b.sx#,3)+'0'+a.xg from a表 a where a.sx#=b.sx#

[开着拖拉机泡妞]

update b表
set gg =left(ltrim(b.sx#),3)+'0'+ltrim(a.xg) from a表 a where a.sx#=b.sx#

[孤独加百列]

LZ 的结果是要取sx#的前四位吧，否则结果怎么是10010而不是1000呢？

update b表
set gg =left(b.sx#,3)+'0'+a.xg from a表 a where a.sx#=b.sx#

又或者是sx#的前三位+gg+0+A表xg

set gg =left(b.sx#,3)+ CAST(gg AS VARCHAR(10)) +'0'+a.xg from a表 a where a.sx#=b.sx#

[tim_spac_126]

select
    gg,  [s#] = left(b.[sx#],3)+'0'+cast(a.xg as varchar)
B表sx#的前3位+0+A表xg
from a, b 
where a.[sx#] = b.[s#]

[cccccccccccc]

update b
set gg =left(ltrim(b.sx#),3)+'0'+ltrim(a.xg) from a a where a.sx#=b.sx#

[houyajin]

select left(ltrim(b.s#),3)+'0'+ltrim(a.xg) as gg,a.sx# as s#
from a,b
where a.sx#=b.s#