I liked the question; I didn't think about it when I answered it much (so I got it wrong :(). The SQL syntax looked right, but needed to read it a bit more carefully I guess.
I just got confused by -- (A); I wasn't sure what was being implied by that when I read the options available to me.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]