I answered the wrong question.:crying: "Objective: Update all the M's to F and all F's to M. " and the result of statement 4 will not be that objective. And as the question was phrased so confusingly I thought perhaps it meant did it succeed in meeting its objective. Clearly not, but then perhaps I ought to read questions more carefully!
Yes, it did mean that and yes, statement 4 will succeed in doing that. If you don't believe that, try running it and see that it does.
For me the question was simple, clear and very basic. Thanks 🙂
Jason...AKA CirqueDeSQLeil _______________________________________________ I have given a name to my pain...MCM SQL Server, MVP SQL RNNR Posting Performance Based Questions - Gail Shaw[/url] Learn Extended Events