>What is wrong with this statment?
>
>

>
>declare @temp table (Zip varchar(5), xYear varchar(4), xQuarter varchar(1));
>
>insert into @temp (zip,xyear,xquarter) values Select substring(PropertyZip,1,5), SUBSTRING(xYear,1,4), SUBSTRING(xQuarter,1,1)
> from [Foreclosure Notices];
>

>
>I am getting a Incorrect Syntax near SELECT keyword. All look correct to me.

You can't have VALUES and SELECT at the same time.

insert into @temp (zip,xyear,xquarter)
Select substring(PropertyZip,1,5), SUBSTRING(xYear,1,4), SUBSTRING(xQuarter,1,1) from [Foreclosure Notices];