高手请看，小弟近日不小心把northwind的employees表的lastname列改成这样啦，不知道如何删除前面的sia以还原样
LastName
siaDavolio
siaFuller
siaLeverling
siaPeacock
siaBuchanan
siaSuyama
siaKing
siaCallahan
siaDodsworth

原来的sql
update dbo.Employees
set lastname='sia'+lastname
请高手帮忙

update dbo.employees set lastname=right(lastname,len(lastname)-3)

update employees set lastname=substring(lastname,4,len(lastname)

又学到知识了！多谢！

多谢各位啦