Problem solved :)

FYI: The answer is to leave out the VALUES keyword.

INSERT INTO basetable (col2, col3, col4) (SELECT col2, col3, col4 FROM Inserted)

>I am trying to create an INSTEAD OF INSERT trigger for a view. The base table has an auto-incremented identity column. Intuitively, I would like to write the following statement:
>
>

>INSERT INTO basetable (col2, col3, col4) VALUES (SELECT col2, col3, col4 FROM Inserted)

>
>Unfortunately, that statement is not allowed in SQL2000. Can anyone suggest the correct way to do this or point me in the right direction?
>
>TIA,
>
>Keith Payne