select wg04=WG01+ '- '+cast(WG02 as int)+ '( '+cast(WG03 as int)+ ') ' from 表名
select WG01+'-'+ltrim(cast(WG02 as int))+'('+ltrim(cast(WG03 as int))+')' AS WG01 from TABupdate TAB set WG04=WG01+'-'+ltrim(cast(WG02 as int))+'('+ltrim(cast(WG03 as int))+')' from TAB
WG01 + --: G1.2.3
'-' + --: -
RTRIM(CAST(WG02 AS INT)) + --: 11
'(' + --: (
RTRIM(CAST(WG03 AS INT)) + --: 3
')' --: )
FROM tb