Pad 0's To Returned Query And Insert Into Temp Table

Got sql to pad 0's from: Formatting Numbers by padding with leading zeros in SQL Server What I want to do is get a users order history from our Navigator database tables. We have

Solution 1:

SELECT  OrderID,
        'Z'+RIGHT('0000000'+CAST(OrderID ASVARCHAR(7)),7)
FROM db1.zm.dbo.zOrder 
WHERE AccountID =631180

Updated following the question edit

DECLARE@OrderNumTabletable (orderNum  varchar(8))

INSERTINTO@OrderNumTable(orderNum)
SELECT'Z'+RIGHT('0000000'+CAST(OrderID ASVARCHAR(7)),7)
FROM db1.zm.dbo.zOrder 
WHERE AccountID =631180

Solution 2:

Can you not just add a Z to the front?

SELECT'Z'+ REPLICATE('0', 7-LEN(OrderID)) + LTRIM(STR(OrderID))