select
case when left(ColA, 1) = '-' then right(ColA, len(ColA) - 1) + '0'
else ColA
end ColA
from
MyTable
=================================================
We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry
Remove first character and add trailing zero
Posted - 10/17/2012 : 19:22:52
