khdm     修改成   khdm
x001              001
x002              002   
x003              003



谢谢

Update Your_Table
Set khdm = substring(khdm, 2, len(khdm))

update 表 set khdm = replace(khdm,'x','')

谢谢，非常感谢

,学习中

update 具体表名 set khdm = substring(khdm, 2, 3)  where khdm='x001'
update 具体表名 set khdm = substring(khdm, 2, 3)  where khdm='x002'
update 具体表名 set khdm = substring(khdm, 2, 3)  where khdm='x003'
还有一种跟简单的、
update 具体表名 set khdm = substring(khdm, 2, 3)  where khdm like 'x%'

[ 本帖最后由 zhlzzl 于 2011-6-21 08:26 编辑 ]