SELECT basic.ID, basic.PID, REPLACE(LTrim(REPLACE([LINC],"0"," "))," ","0") AS Linc, basic.STATUS, basic.PARTIAL, basic.DATE, basic.TAG_DATE, basic.FILE_NAME, basic.MAST_NAME INTO new_basic
FROM basic
GROUP BY basic.ID, basic.PID, REPLACE(LTrim(REPLACE([LINC],"0"," "))," ","0"), basic.STATUS, basic.PARTIAL, basic.DATE, basic.TAG_DATE, basic.FILE_NAME, basic.MAST_NAME;