SQL Server 常用函数

PadRight

select
right(replicate('0',9)+ rtrim(ltrim(a.field)),9)
from Table1 a