Mike,

AFAIK, you've to list all columns excluding Identity.

>want to copy / insert a record into a table from another record from the same table. I'm using
>
>

>insert into statefl select * from statefl where st = 'AL'
>

>
>I get the Identity error.
>Is there such a thing as "except a field"?
>Can you show me how to do this?