select right('00000'+ltrim(colname),5) from table
Powered by: 博客园 Copyright © 2024 shenyixin Powered by .NET 8.0 on Kubernetes