Knowledge Draftsman (5/15/2013)
So, I did a little playing around myself, and discovered that as far as performance goes there is zero difference. At least with the size data set that I was using.
How many rows was that? I ask because I can see the first query taking twice as long if something is found.
--Jeff Moden
Change is inevitable... Change for the better is not.