>Thanks for the help, Mike, that worked. Is there a way or an advantage to using SqlServer's FROM extensions?
>
>-Bill

The FROM clause for UPDATE and DELETE are extensions to TSQL. TSQL is the SQL language implemented by Microsoft SQL Server. As extensions, they are not part of the ANSI standard. I perfer to stay ANSI whenever possible.

-Mike