Thanks for posting but I think this has really sparked up the age-old question on whether there is a difference between COUNT(*) and COUNT(1). In my early days I believed there was a difference but now understand that they are actually synonymous - there is no difference. If my current understanding is wrong then i would really like to know more about it.