3 个解决方案
#1
substring(colname,2,datalength(colname));
#2
update tablename set fieldname=right(fieldname,datalength(fieldname)-1)
#3
高手去这儿看看吧!
http://expert.csdn.net/Expert/topic/1733/1733233.xml?temp=7.139224E-02
http://expert.csdn.net/Expert/topic/1733/1733233.xml?temp=7.139224E-02
#1
substring(colname,2,datalength(colname));
#2
update tablename set fieldname=right(fieldname,datalength(fieldname)-1)
#3
高手去这儿看看吧!
http://expert.csdn.net/Expert/topic/1733/1733233.xml?temp=7.139224E-02
http://expert.csdn.net/Expert/topic/1733/1733233.xml?temp=7.139224E-02