>I agree, for a one-SQL statement, but...
Cool... I prefer to code assuming the gotcha regardless if UNION eliminates the gotcha or not... otherwise I get into the habit of forgetting where the gotcha can and can't occur... so I always assume the gotcha. You're too smart for me :)
Brandon Harker
Sebae Data Solutions