删除一列数字当中的头一个字符

Question

Update Jfgl_FeeRate Set vcCalledHead ='2'+vcCalledHead
利用上面的语句我把所有vcCalledHead这一列数字编号都加上一个打头字符2
如果我准备删除vcCalledHead这一列数字编号打头字符2
怎么写SQL语句？？？

Answer 1

Update Jfgl_FeeRate Set vcCalledHead =stuff(vcCalledHead,1,1,'')

Answer 2

Update Jfgl_FeeRate 
set vcCalledHead =right(rtrim(ltrim(vcCalledHead)),len(rtrim(ltrim(vcCalledHead)))-1)
where vcCalledHead like '2%'