>I am using MSSQL7 and put the following code in a SP to create a table based on some columns from an already existing table.
>

>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 '.'"
>
>Huh? Help?

You seems to have spaces into your field/table name. You need to enclose your names between square brackets if they contains invalid characters.

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