>As others have posted, there is a "work around" for this behavior change. However, I have to ask, what kind of results are you looking for when you execute a query like this? Do you expect to get any meaningful data? The only valid values will be in Field1. All other data is suspect and should be treated as invalid.

Here is the complete statement I was using:

select *, count(field1) as cnt from tblData Group By field1

and thank you for the help. :)