set @TempTO1=(select AAA from Table2)
set @TempTO2=( Replace(@TempTO1, '-','0'))
set @TempTO3 =Right(@TempTO2, 3)
----你的set @TempTO3 =(Right(@TempTO2, 3))
~~~~~~~~~~~~~~^^^~~~~~~~~~~~~~~~~^^^
^^^处,你的括号是全角的.
set @TempTO2=( Replace(@TempTO1, '-','0'))
set @TempTO3 =Right(@TempTO2, 3)
----你的set @TempTO3 =(Right(@TempTO2, 3))
~~~~~~~~~~~~~~^^^~~~~~~~~~~~~~~~~^^^
^^^处,你的括号是全角的.
set @TempTO1=(select top 1 AAA from Table2)
set @TempTO3 =Right(rtrim(@TempTO2), 3)