Archives of the TeradataForum

Message Posted: Fri, 10 May 2002 @ 12:58:56 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Sounds more like what you want to do is an "Update" as it appears that you are modifying values where there are rows already in the table. If this were not the case, then the where clause would make no sense. Tom is correct however, there is no provision for a where clause in the insert statement syntax.

Rick Sumner

	<Prev	Next>		<<First	<Prev	Next>	Last>>