Worked like the proverbial charm....thanks for the quick reply, you guys are great

I have the same problem, with my data imported as nvarchar in the format MMDDYYYY (01012008, for example.) I get an out-of-range datetime value when I attempt the alter column...