SELECT CAST('000123' AS INT)SELECT LEFT('000000',6 - Len(123)) + CAST(123 AS VARCHAR)
--Cast Or Convert Function --Example Declare @t Varchar(10) Declare @t1 Int Set @t1=123 Set @t='000123' --可以将字符 '000123' 转换为数字123 Select Cast(@t as Int) ---123转换为 '000123' Select '000'+Cast(@t1 As Varchar)
--Example
Declare @t Varchar(10)
Declare @t1 Int
Set @t1=123
Set @t='000123'
--可以将字符 '000123' 转换为数字123
Select Cast(@t as Int)
---123转换为 '000123'
Select '000'+Cast(@t1 As Varchar)