Why is this query incorrect?

[melissafvoelker]

SELECT [FA Ctr], [SAP Co], [SAP Ctr], [GL Co],
Format (([SAP Co],"0000") AS NewField), (([cst ctr], "0000000000") as costcenterappended) INTO [Interim Table]
FROM Asset_Map;

 

[FoFa]

Format (([SAP Co],"0000") AS NewField), (Wrong Syntax)
Format([SAP Co],"0000") AS NewField,
Same with costcenterappended

Just to start