>Select >Convert(int,'0000') as cvi_company , >Convert(Char(9),'Unknown') as cvi_vendor , >Convert(Char(15),'xxxxxxxxxxxxxxx') as cvi_edi_nbr , >AP Invoice.Invoice Number >From DevFWap.AP Invoice >Into DEVFWap.apcinvoice >>I get an error "Incorrect Syntax near '.'"
Select Convert(int,'0000') as cvi_company , Convert(Char(9),'Unknown') as cvi_vendor , Convert(Char(15),'xxxxxxxxxxxxxxx') as cvi_edi_nbr , AP Invoice.[Invoice Number] From DevFWap.[AP Invoice] Into DEVFWap.apcinvoice