SQL去掉前面的0 SELECT stuff(substring('000004564972000',0,80),1,patindex('%[^0]%',substring('000004564972000',0,80))-1,'')