SQL去掉前面的0

SELECT stuff(substring('000004564972000',0,80),1,patindex('%[^0]%',substring('000004564972000',0,80))-1,'')

posted @ 2013-05-24 02:05 Buu 阅读(830) 评论(0) 收藏举报