>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.

lose the values keyword. Only use values if you are secifying a set of values. If you are using a select statement, don't include the word 'values'.