SELECT Linc.ID, Linc.Title_ID, REPLACE(LTrim(REPLACE([Linc_no],"0"," "))," ","0") AS Linc, Linc.Short_Legal, Linc.Condo_shares, Linc.Mineral_rights, Linc.Area_type_imperial, Linc.Area_by_Linc_imperial, Linc.Area_type_metric, Linc.Area_by_Linc_metric INTO new_Linc
FROM Linc;