>> That would explain everything. Except why it's a VARCHAR instead of >> DATE. But that's a whole 'nother discussion. > > As I understood OP, it's a staging table :) Right. And it's exactly because the original source has bogus data that I need a staging table to load it up and study it and fix it. -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxx http://www.killerbytes.com/ (303) 722-0567 voice