sql补零
update Promote set PromoteSName=right('000'+cast(PromoteSName as varchar),3)
sql去空格
update Promote set PromoteSName=ltrim(PromoteSName)
sql补零
update Promote set PromoteSName=right('000'+cast(PromoteSName as varchar),3)
sql去空格
update Promote set PromoteSName=ltrim(PromoteSName)
转载于:https://www.cnblogs.com/codeloves/archive/2013/05/17/3083404.html