> Could someone please post the results of these queries on Oracle, > DB2 or SQL Server?
On MS SQL Server 2000, your queries result in the following: a c ----------- ----------- 2 -998 1 3 (2 row(s) affected) foo ----------- -1000 1 2 (3 row(s) affected) a c ----------- ----------- 2 -998 1 3 1 4 2 5 (4 row(s) affected) ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------