@TT_MARK I understand that you dont ALWAYS want to select everything, but your statement was that you should NEVER select everything. I was (and am) disagreeing with that. I have plenty of times where I need to get all columns out to either display or cache as a session variable.